Countif

Hi,

I have a situation where I need to have a count of "Pass" in a certain coulmn say J, and the count should satisfy specific condition on another column E.

E F
A Pass
B Pass
C Fail
A Fail
A Pass

I need the number of "Pass" from F if the column E has A, in this situation it should return 3. I used countif it returns someother value.

Please help me on this

Hi

I'm a bit confused, I would have thought that the answer you are looking for would be 2 as there are 2 "A"s that also have Pass, the other Pass has "B".

If you want the result 2, the following would work, where the first range is the range of letters and the second is the range where the Pass/Fail is.

This is an array formula so should be entered with Ctrl+Shift+Enter

=SUM(IF(A1:A6="A",1,0)*IF(B1:B6="Pass",1,0))

if you just want to check if the first column contains A and then count the number of passes then below would work

=IF(COUNTIF(A1:A6,"A")>0,COUNTIF(B1:B6,"Pass"))

Hope this helps