=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?

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


--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



wrote in message
ups.com...
=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?

"0:00:30"

"Bob Phillips" wrote:

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


--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



wrote in message
ups.com...
=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?

Well, I tried the formula you provided Bob, but it doesn't work
correctly. It gave me some number like 4897, and we don't even come
close to taking that many calls total, let alone just the ones that
are less than 30 seconds. Any other ideas? I've tried to set up an
array formula, but I just can't seem to get it.

Also on a side note, I don't mean to be rude and appreciate any help
that people can provide, but Teethless mama, I honestly don't know
what kind of HELP that reply was.

I think Bob's formula is counting anything less than 30 minutes, and
Teethless Mama was correcting this. Try this modification:

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

Hope this helps.

Pete

On Feb 8, 3:35 pm, wrote:
Well, I tried the formula you provided Bob, but it doesn't work
correctly. It gave me some number like 4897, and we don't even come
close to taking that many calls total, let alone just the ones that
are less than 30 seconds. Any other ideas? I've tried to set up an
array formula, but I just can't seem to get it.

Also on a side note, I don't mean to be rude and appreciate any help
that people can provide, but Teethless mama, I honestly don't know
what kind of HELP that reply was.

Pete, thanks for the quick reply. I did try the updated formula that
you provided, however I got the exact same result as with Bob's
formula. Is there more information that I can try to provide in order
to assist figuring this out?

Layout a sample of the data and the expected result. Be sure to count some
of the items that count wrongly in your formula.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



wrote in message
oups.com...
Pete, thanks for the quick reply. I did try the updated formula that
you provided, however I got the exact same result as with Bob's
formula. Is there more information that I can try to provide in order
to assist figuring this out?