Feb 24 2020 05:04 AM
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 appear in the smaller table on the right.
This workbook will eventually be full of lots of different measures and I want to count the amount of "Pass" for every single one of them to then convert into a Pass Rate (%).
I've so many formulas and combinations including COUNTIF, INDEX, MATCH, SUMIF and I just cannot figure out how to do this. It seems so simple but I'm struggling so much.
Any help would be really appreciated!
Feb 24 2020 05:27 AM - edited Feb 24 2020 05:42 AM
Feb 24 2020 05:52 AM
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,
Feb 24 2020 06:15 AM
Feb 24 2020 06:18 AM - edited Feb 24 2020 06:21 AM
Feb 24 2020 08:51 AM - edited Feb 24 2020 09:05 AM
@ryanjdavis95 Replicated your example in the attached workbook (different table names though), which I believe to holds the solution you want.