kalmar27615
New Member
- Joined
- May 12, 2014
- Messages
- 7
Hello everyone, I have the following issue I'm hoping you can help me with:
I am trying to count the number of occurrences with 2 criteria: =COUNTIFS(B:B,"Birmingham",C:C,"PASSED")
<tbody>
</tbody>
The location of the "PASSED" entry is dynamic and is not always directly across from "Birmingham" which is why I am not getting the correct results. Is there a solution to this? Thank you all in advance!
I am trying to count the number of occurrences with 2 criteria: =COUNTIFS(B:B,"Birmingham",C:C,"PASSED")
AL001 | Birmingham | |
AL001 | CV | |
AL001 | PHY | PASSED |
AL001 | No | |
AL001 | Vendor | |
AL002 | Birmingham | PASSED |
AL002 | PHY | |
AL002 | Vendor | |
AL003 | Birmingham | |
AL003 | DA | PASSED |
<tbody>
</tbody>
The location of the "PASSED" entry is dynamic and is not always directly across from "Birmingham" which is why I am not getting the correct results. Is there a solution to this? Thank you all in advance!