COUNTIF with condition question

T

tr7749

Hi,
I have worksheet as follow:

Code
-------------------

*********************************
| Result |User Part1|User Part2|
|-------------------------------|
|pass/Fail|UserA |UserB(orA)|
|...............................|
********************************
-------------------


Now I want to count how many unit which userA built fail(or pass) test
How am I going to do that? for example, UserA build 20unit anh has
unit fail test. What function do I need to enter to get tha
result(5)?

Thank yo
 
Top