Assistance with Formula
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.
|