Formula for more than one criteria
 

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

Formula for more than one criteria
 

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

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

Formula for more than one criteria
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Clari" wrote in message
...
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