| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif with two criteria
Can someone help me put together a formula that can count with 2 criteria
Example I have calls to Citys and length of the call I need a formula to coung Greater than 20 minutes, another greater than 30 and greather than 60 minutes.. New York 0:25:00 Dallas 0:16:00 Cleveland 0:12:00 New York 0:06:00 New York 0:21:00 The answer for NY On this would be 2 calls greater than 00:20:00 Thank you |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Countif with two criteria
hi,
=SUMPRODUCT(--(A1:A5="New York")*(C1:C5(20/3600))) =SUMPRODUCT(--(A1:A5="New York")*(C1:C5(30/3600))) =SUMPRODUCT(--(A1:A5="New York")*(C1:C5(30/3600))) -- isabelle Le 2012-11-05 17:27, a écrit : Can someone help me put together a formula that can count with 2 criteria Example I have calls to Citys and length of the call I need a formula to coung Greater than 20 minutes, another greater than 30 and greather than 60 minutes.. New York 0:25:00 Dallas 0:16:00 Cleveland 0:12:00 New York 0:06:00 New York 0:21:00 The answer for NY On this would be 2 calls greater than 00:20:00 Thank you |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Countif with two criteria
On Monday, November 5, 2012 11:53:36 PM UTC-6, isabelle wrote:
hi, =SUMPRODUCT(--(A1:A5="New York")*(C1:C5(20/3600))) =SUMPRODUCT(--(A1:A5="New York")*(C1:C5(30/3600))) =SUMPRODUCT(--(A1:A5="New York")*(C1:C5(30/3600))) -- isabelle Le 2012-11-05 17:27, a �crit : Can someone help me put together a formula that can count with 2 criteria Example I have calls to Citys and length of the call I need a formula to coung Greater than 20 minutes, another greater than 30 and greather than 60 minutes.. New York 0:25:00 Dallas 0:16:00 Cleveland 0:12:00 New York 0:06:00 New York 0:21:00 The answer for NY On this would be 2 calls greater than 00:20:00 Thank you Thank you Isabelle, that works :) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Several Countif criteria | Excel Worksheet Functions | |||
| Using COUNTIF with two different criteria | Excel Programming | |||
| Countif W/ 2 Criteria | Excel Worksheet Functions | |||
| Countif using format criteria not number criteria? | Excel Worksheet Functions | |||
| Countif using format criteria....not number criteria? | Excel Worksheet Functions | |||
Linear Mode
