Several subtotals

  • Thread starter Thread starter Rich
  • Start date Start date
R

Rich

I am using Excel 97.

In the pull down menus, I am limited to 1 sub total. Is there a way
that I can have 2 subtotals. The report should look like this :

Broker # Account # Price Amount
ABC 123 $ 1 $10
123 $ 1 $10
Total for 123 $ 2 $20

XYZ 321 $1 $10
321 $1 $10
Total For 321 $2 $20

Can I do this with subtotals pull down menus?
 
You can subtotal more than one column. Just put a checkmark in those fields
that you want subtotalled.

If you were asking about having multiple levels of subtotals, then just run
data|subtotal multiple times.

Make sure you uncheck the "replace current subtotals" box.
 
Back
Top