Subtotal a filtered range

Originally Posted by mdarcey

I am aware of the 109 function, but this only ignores cells that are hidden

No, that's not correct. This formula only totals those values not hidden by filtering

=SUBTOTAL(9,A:A)

If you change the 9 to 109 then rows hidden by filtering will still be excluded...additionally any rows hidden using the Hide command will also be ignored. If you never use Hide then either one should work