Subtotals equal zero when collapsed to Level 2

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

Guest

I have been working on a spreadsheet for a couple of days and all of a sudden
the subtotals are showing zeros when the rows are collapsed to the second
level. This was not happening before. The subtotals are correct when the
rows are expanded. Help?
 
Are you collapsing the rows using data|filter|autofilter or the outlining
symbols to the left (created by data|subtotals).

Remember that =subtotal() is smart enough to ignore rows hidden by autofilter.
 
Thank you! I didn't realize that one of my auto filters was selected. So,
although I was collapsing the rows using the numbers to the left, I was
getting the zeros from the auto filer.
 

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

Subtotals Don't Collapse Correctly 1
Subtotal error to expand Outline Levels 1
subtotals showing 0 in summary level// 2 subtotal levels 2
Horizontal Subtotals 3
Change row color on event 12
subtotal levels 7
Copying from Subtotal Data 2
Getting Text data using the Data - Subtotal feature 1

Back
Top