How to count PASS/FAIL cells in a range...

Hi. I have a test log with PASS/FAIL. These results are logged in Excel under the column heading PASS/FAIL.
How do I count the number of PASS or FAIL using VBA macro?

So far I have tried:

Please Login or Register  to view this content.

This one did not work either:

Please Login or Register  to view this content.

the error is at the name = Range("PASS/FAIL").Select line.

My thought process: once I had selected a range, I can now freely "look" at each string in a cell in that range. Not correct I guess.

Please advice. thank you.

p.s. all this is currently done in the active sheet.

Hi, dtvonly,

you may use CountIf to check the number for each item, CountA if only values are in that range, get the last cell via

Please Login or Register  to view this content.

if you have the header in row 1.

The command you tried to use assumes that there would be a range being named like that which my Excel doesn´t allow.

Ciao,
Holger

Error at line Range("PASS/FAIL").Select line is because the PASS/FAIL is not valid Named Range. I assume that PASS/FAIL is a named range in your code which you are referring to. If this is the case change this to a valid Named Range like Pass_Fail and then you can try the following code to get the count......

Please Login or Register  to view this content.

or like this.......

Assuming that column C contains the Pass or Fail. If not, change the column C in red color to the column of your choice in the code.

Please Login or Register  to view this content.

2 ways...if you want to use a formula
put a value in col C for pass, and col D for FAIL, using =IF(B2="PASS",1,"")
then sum the columns
or
else VBA code:

Please Login or Register  to view this content.