Excel 2003 Data/Subtotal error

C

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.
 
P

PeterAtherton

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
 
C

Courtney

They already are. But thanks for the reply.

("PeterAtherton" wrote:

Courney

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

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).
 
Top