SUBTOTAL

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

Hi, I have subtotal at the bottom of a spreadsheet and is used when filtering
on a group of rows. I have a problem that if I change the subtotal row or
chnge the format of the cell it stops appearing in the filter. Why is this?

Thanks
 
Your filter criteria might not match with the subtotal row.

Remember to Click Yes, if this post helps!
 
I like to add the =subtotal() fields in row 1, then the headers in row 2 and the
data in rows 3:xxx.

Then I can freeze panes showing the first two rows and see those subtotals
easily.

If I have to have the subtotals at the bottom, I'd include an empty row between
the data and the subtotal row.

And when I applied data|filter|autofilter, I'd select the range exactly--I
wouldn't let excel guess. I don't want it to include that empty row or the
subtotal row.
 

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

Back
Top