Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
=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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I was looking to get assistance with a formula in Excel 2002 | Excel Worksheet Functions | |||
Formula Assistance Please | Excel Worksheet Functions | |||
formula assistance - percentage difference | Excel Worksheet Functions | |||
Need assistance with a formula | Excel Worksheet Functions | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel |