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