Formula for more than one criteria
Thanks!! It worked.
--
Clari
"T. Valko" wrote:
Try these:
Assume no empty time cells
D2 = C7
=SUMPRODUCT(--(A2:A7=D2),--(B2:B7<=TIME(0,30,0)))/COUNTIF(A2:A7,D2)
D3 = BNP
=SUMPRODUCT(--(A2:A7=D3),--(B2:B7<=TIME(1,0,0)))/COUNTIF(A2:A7,D3)
Format as Percentage
--
Biff
Microsoft Excel MVP
"Clari" wrote in message
...
Hello
I need to make my life a little bit easier and I need your help.
I have this chart:
Procedure Time from Rcvd to Verified
BNP 1:26
BNP 0:44
C7 0:24
CBC 0:29
C7 0:25
C7 0:35
I need to know the percentage of C7 tests that were performed within 30
minutes, the % of BNP performed within one hour, and so on.
I will really appreciate your help.
--
Clari
|