Formula for more than one criteria

  • Thread starter Thread starter Clari
  • Start date Start date
C

Clari

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.
 
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
 
Thanks!! It worked.
--
Clari


T. Valko said:
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
Click to expand...
 
Back
Top