Maybe...

Multilevel subtotals are in the wrong position in Excel 2002 and in Excel 2003
http://support.microsoft.com/default...b;en-us;831824



SPC wrote:

Subtotals in my worksheet are not dropping in the correct order:
territory # product # $$$
100 40 5
100 40 5
100 50 20
First I subtotal product number, totals of prod.# 40 is 10 and 50, 20. when
I subtotal again to get a total of territory, prod # 50 goes below the
territory subtotal, but the line it is subtotalling is still above & included
in the territory total.

Help?

--

Dave Peterson