I have imported some data using VBA in an excel file. I have a 100's of parts numbers in column A and corresponding 6 numerical values for each part in column C. (For example, if "A5" has part number then data would be in "C5:C10"). I also have a numerical criteria set in another cell "B2". I want to count the number of parts that failed and put that number in "D2". The failure criteria is if any 1 out of 6 values for a part is above the set limit in "B2", then it is considered as failed. I want to apply it to all the parts in the sheet. I was able to make it work for 1 part using OR function, but I cannot figure out how to apply this for the other group of cells in the whole column C where all the data is. I could use VBA but I don't know if changing "B2" would update "D2" automatically. See attached image for more clarity. Thank you.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
