I like to put my totals in row 1, my headers in row 2 and my data in rows 3:xxx.

Then I can use =subtotal(#,xx:xx) in row one to get those nice subtotals.

And =subtotal() will ignore those rows hidden by an autofilter.

Skeeve1313 wrote:

Is there a way to have Excel give totals for filtered data automatically when
I filter the data?

--

Dave Peterson