=SUMPRODUCT(--(ISNUMBER('Feb ''07'!G2:G4999)),
--('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
oups.com...
Alright, I'll do my best to try to get this formatted so it hopefully
makes a little sense.

Column F Column G
HNR-B13 :01:09
System :00:10
HNR-B13 :10:40
System :00:03
System :00:08
HNR-B13 :03:13
System :00:21
System :00:36
HNR-C17 :04:08
HNR-B12 :07:14
HNR-B12 :02:13
HNR-B14 :00:06
HNR-B02 :00:08

There's the sample of the data. Now, the result needs to be all of
the calls that are less than or equal to 30 seconds, minus all of the
calls in calls that come in under the System heading in column F that
are less than or equal to 30 seconds. So in this example there are 6
total calls that are <= :00:30 and there are only 4 calls w/ the
System heading, therefore the desired result is 2. With the original
formula that I was using, it would have generated a result of 1.