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