hi

does anyone know how to subtotal a range that has been filtered? I am aware of the 109 function, but this only ignores cells that are hidden

so lets say column A details - Jan, Feb, March, April
column B has monthly totals

I then filter A to show only Jan & Feb. If I subtotal column B the sum includes the value's for March and April?

Any ideas?