Subtotals equal zero when collapsed to Level 2

[kbssailor]

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?

[Dave Peterson]

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.

kbssailor wrote:
>
> 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?

--

Dave Peterson

[kbssailor]

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.

"Dave Peterson" wrote:

> 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.
>
> kbssailor wrote:
> >
> > 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?
>
> --
>
> Dave Peterson
>