Another article updated. Thanks, Dave.
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"Dave Peterson" wrote in message
...
It doesn't look right is kind of vague, but maybe...

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



Diane wrote:

I have a database I want to subtotal by both State and City. So for
example,
I want to see subtotals for individual towns such Dallas, Houston,
Cleveland
and Toledo, but then I want to see totals for Texas and Ohio.

I sorted first by State, then City and created subtotals for the sales
amounts based on the State. All is OK.

I created the secondary subtotal just like the first one except at each
change in City, and I told it not to replace subtotals. It doesn't look
right. Does any of this make sense? Any ideas what I'm doing wrong?

TIA
Dino

--

Dave Peterson