Dianne,
I tried a simple spreadsheet with subtotals. I expanded and collapsed
various outlines with no effect on the totals.
My guess is that one or more of the subtotals was created incorrectly?
In XL's help, it mentions the following:
a.. If there are other subtotals within ref1, ref2,. (or nested subtotals),
these nested subtotals are ignored to avoid double counting.
a.. SUBTOTAL will ignore any hidden rows that result from a list being
filtered. This is important when you want to subtotal only the visible data
that results from a list that you have filtered.
Do either of these situations apply?
Regards,
Kevin
