Several subtotals

[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?

 

[Dave Peterson]

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.

 

[NickHK]

Rich,
Do some "Sum of price" have any meaning though?

NickHk