LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I was looking to get assistance with a formula in Excel 2002 cashman Excel Worksheet Functions 7 July 21st 06 02:15 PM
Formula Assistance Please yukon_phil Excel Worksheet Functions 8 July 19th 06 03:53 PM
formula assistance - percentage difference Dave Excel Worksheet Functions 2 June 25th 06 04:00 AM
Need assistance with a formula esmer Excel Worksheet Functions 5 March 7th 06 10:06 PM
Dynamic Range with unused formula messing up x axis on dynamic graph [email protected] Charts and Charting in Excel 2 February 2nd 06 08:02 PM


All times are GMT +1. The time now is 01:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"