| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| if formula with between value as a criteria | Excel Worksheet Functions | |||
| Sum If Formula with 3 criteria | Excel Worksheet Functions | |||
| 2 Criteria Formula | Excel Discussion (Misc queries) | |||
| 2 criteria for a COUNTIF formula? | New Users to Excel | |||
| CORREL formula with criteria | Excel Worksheet Functions | |||
Linear Mode
