Subtotaling

[C-Money]

I have a sheet that has three fields that I want to run
subtotals on: Division, Zone, and Rep. So far I've done
subtotaling for each rep in the sheet, but now I need to
do first a subtotal of the division, the zones within a
division, and then the individuals in that zone. Is there
a way that I can do it without having to remove the
subtotal I've already done for reps. Reps are in the D
column, Zones in F, and Division in E. Thanks

 

[Andy B]

Hi

Start with the Division, then the Zones and then the Reps. Just go to Data /
Subtotal each time, change the 'At each change in' to the relevant column
and make sure you uncheck the 'Replace Current Subtotals' box.

 

[Guest]

Thanks. It worked for me

-----Original Message-----
Hi

Start with the Division, then the Zones and then the Reps. Just go to Data /
Subtotal each time, change the 'At each change in' to the relevant column
and make sure you uncheck the 'Replace Current Subtotals' box.

--
Andy.





.

 

[Andy B]

Thanks for the thanks!

--
Andy.

Thanks. It worked for me