Excel 2003 Data/Subtotal error

[Courtney]

Before I upgraded to Excel 2003, I used to take financial expense and
subtotal by cost department and then a secondary subtotal by account. So I
would have two subtotals based on the same data range.

Now that I have upgraded, the primary subtotal still works. But the
secondary subtotal get confused half way down the page. It skips the last
line of expense for each cost center and includes it in the subtotal above.

Has anyone else had this problem.

 

[PeterAtherton]

Before I upgraded to Excel 2003, I used to take financial expense and
subtotal by cost department and then a secondary subtotal by account. So I
would have two subtotals based on the same data range.

Now that I have upgraded, the primary subtotal still works. But the
secondary subtotal get confused half way down the page. It skips the last
line of expense for each cost center and includes it in the subtotal above.

Courney

Try Sorting the list by Department, Account before you apply the subtotals.

PeterAtherton

 

[Courtney]

They already are. But thanks for the reply.

("PeterAtherton" wrote:

Courney

Try Sorting the list by Department, Account before you apply the subtotals.)

 

[GaryO44]

I have experienced the same problem and created another posting today
(6/27/2005).

 

[Courtney]

What did you title your post? I'd like to check it for responses.....

 

[GaryO44]

Multiple subtotals out of order now. If you search for "subtotal" you should
see it. I only find 4 hits when searching for it (under Excel application
errors posts, that is).