Countif with two criteria

J

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
 
I

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top