Countif with two criteria

[jc9972003]

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

 

[isabelle]

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

 

[jc9972003]

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, (e-mail address removed) 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