My problem is that when I filter a column and then, for example, sum the
values in the column I get exactly the same answer as before summing. This
happens with one or more filters and seems ridiculous since thats precisely
what I want to use the filter for.
Can someone please explain if i'm being very stupid or if this is really a
limitation of the filter function. thanks

hi ?

look in help for the subtotal worksheet function

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Filtering problem" <Filtering wrote in message
...
My problem is that when I filter a column and then, for example, sum the
values in the column I get exactly the same answer as before summing. This
happens with one or more filters and seems ridiculous since thats precisely
what I want to use the filter for.
Can someone please explain if i'm being very stupid or if this is really a
limitation of the filter function. thanks