Countif

[princeka47]

Dear all,
Am working in software testing. we used to maintain the details in Excel sheet only. now i had a doubt how to use the countif with two given conditions.i'll give my requirement below.
i need to combine two colums
1) the Tester name.
2)Testing Status;
and in the report i need to find the total number of testing work that is completed by a particular tester
Tester Name
X
Y
Z
Status
Assigned
Completed
On going
i need to find the number Mr.X with status completed
Thanks in advance

[NBVC]

In XL2003, the best way to use multiple conditions is to use SUMPRODUCT

e.g

=Sumproduct(--(A1:A100=X1),--(B1:B100=Y1))

this counts the number of items in A1:B100 that satisfy inputs of X1 and Y1 combined.