What exactly do you want to have as a result when you are done? The
approach may change depending upon your needs.

"Steve Simons" wrote:

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