In Excel
DataSubtotals screen make it possible to select more than one column in the
"At each change in" field.
This will make the nested subtotals much more easier.


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

You can just run Data|subtotals as many times as you want.

Make sure you uncheck "replace current subtotals" if you want to keep the
previous subtotals.

Zsolt Dubovanszky wrote:

In Excel
DataSubtotals screen make it possible to select more than one column in the
"At each change in" field.
This will make the nested subtotals much more easier.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

--

Dave Peterson

Yes, You right, but it is very confusing and not well explained in many
places in the help and very unconvenient. It would be much more convenient
and obvious if you can select in thementioned feld with checkboxes as many
columns as many you want to have subtotal levels.
This was the sugession for future development for a simpleface user to make
Excel user friendly.
Sincerely, Zsolt Dubovanszky

"Dave Peterson" wrote:

You can just run Data|subtotals as many times as you want.

Make sure you uncheck "replace current subtotals" if you want to keep the
previous subtotals.

Zsolt Dubovanszky wrote:

In Excel
DataSubtotals screen make it possible to select more than one column in the
"At each change in" field.
This will make the nested subtotals much more easier.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

--

Dave Peterson