Forum Discussion
Please help. I'm struggling to Count Yes'/No's based on matching text.
Hi there, I want to count in column K the number of "Pass" in 'Test Pass/Fail' column of the left table. (See image). I want to find the pass count for each individual measure and have them a...
Hi Abiola1
Thanks for your suggestion.
I tried what you suggested and it seemed to work until I copied it down.
It's counting a Fail as Pass In Cell K5. I also tried the formula to count Fails in an additional column on the table on the right and that is having the same problem.
Any suggestions on what's going on?
Cheers,
ryanjdavis95 Replicated your example in the attached workbook (different table names though), which I believe to holds the solution you want.