COUNTIF with condition question

[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

 

[Frank Kabel]

Hi
see:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html