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...
This is what your formula will look like in cell K5.
=COUNTIFS(Table3[Measure],J5,Table3[Test Passs/Fail],"Pass").
Click enter and copy down the formula... It should be fine
=COUNTIFS(Table3[Measure],J5,Table3[Test Passs/Fail],"Pass").
Click enter and copy down the formula... It should be fine