View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] jc9972003@yahoo.com is offline
external usenet poster
 
Posts: 38
Default 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