View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] Destrachan@gmail.com is offline
external usenet poster
 
Posts: 25
Default Assistance with Formula

=COUNTIF('Feb ''07'!G2:G4999, "<=:00:30")-COUNTIF('Feb ''07'!F2:F4999,
"System")

That's the beginning formula that I'm working with. Now, this is to
assist in tracking calls that come in that are less than or equal to
30 seconds, minus the calls that come in under the "System" heading.
Seems simple enough, however the oversight w/ the original formula is
that some of the calls that come in under the "System" heading now are
more than 30 seconds and it's throwing off the numbers. I've been
beating my head against my desk to try to figure out a formula and I'm
not succeeding in anything besides giving myself a headache.
Something tells me that I'm making this much harder than it should
be. Is there anyone that can help me out?