How do I reorder multiple criteria sub-totals?

G

Guest

I've got an issue with sub-totalling on multiple criteria in Excel. When you
look at following screen print, you will see that there are sub-totals on the
New G/L and New CC# (first sub-total was New CC#, then New G/L) On the 3rd
line, you see a sub-total for 600202 that belongs above the sub-total for
1010340, on the 8th line a sub-total for 600207 that belongs above the
sub-total for 3010550 and on the 13th line a sub-total for 600207 that
belongs above the sub-total for 3010555.

Val.in rep.cur. New G/L New CC#
8,758 1010340 Total
8,758 600202 Total
46,043 600200 Total
2,055 600202 Total
34,216 600205 Total
104,444 3010550 Total
22,129 600207 Total
55,692 600200 Total
2,578 600202 Total
34,304 600205 Total
118,446 3010555 Total
25,873 600207 Total
231,647 Grand Total

This was never an issue with '97, but since I installed '03 a couple of
weeks ago, it has been an issue. Sick of cutting and pasting.....hoping
someone can help me solve this ASAP.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I sub-total by multiple criteria in Excel? 1
How do I reflect a a sum of values in the sub form in the main form 4
How do I save a totals value from a subform to a table field 4
HOW DO I GET COLUMN TOTALS TO AUTO UPDATE? 2
How to add a row to a table with totals? 4
E-mail macro - how do I attach multiple attachments? 1
I'm being offered an update I don't want 5
Multiple Search Criteria - One works other does not. 1

Top