Subtotal should only count/sum visible data. What are you filtering/summing
on?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Steve Simons" wrote in message
...
Hi

I have seen from looking through this NG how to use subtotal to count
or sum filtered data, which is great, but I've been hunting around for
nearly an hour to find the answer to what I need to do. I'm sure it
can't be too difficult, but I'm having a one of dem days . . .

I have filtered data, let's say in column A I have departments listed,
with 20 occurences of dept "Accounts". When I filter the data on
another field only 15 occurrences of "Accounts" are visible.

I need to be able to count (and and also sum) the number of occurences
of "Accounts" within the filtered data. If I use subtotal for this I
get 20 returned.


TIA

Steve