Excel 2003 Data/Subtotal error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Courtney said:
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.
Click to expand...

Courney

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

PeterAtherton
 
They already are. But thanks for the reply.

("PeterAtherton" wrote:

Courney

Try Sorting the list by Department, Account before you apply the subtotals.)
 
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).
 
Back
Top