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

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

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 :)