Totals in my filtered worksheet

[Guest]

I have a large worksheet that is filtered. At the bottom of the worksheet I
have totals for some of the columns. When I filter on a column the totals
disappear. This just started happening. What have I done????

Thanks!

 

[Dave Peterson]

Do you mean the rows with the totals (or Subtotals) are hidden?

If yes, then that row is part of the autofilter range.

Maybe you can leave an empty row between the data and the total/subtotal row.
Personally, I like to put the total/subtotals in row 1, headers in row 2 and
data in rows 3:xxxx.