Filtering problem

[Guest]

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

 

[Ron de Bruin]

hi ?

look in help for the subtotal worksheet function