Totals in my filtered worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filter Subtotal Problems 5
keep total formulas / rows when apply filter 1
Need the grand total pivot table filtered worksheet? 1
Auto Filter question 4
Auto filter count 3
Using Filter more than once 2
Creating A List of Items Between Two Numbers 2
SumProduct and Sum only Filtered data 3

Back
Top