sum sub levels only.
 

Hi there,

My name is Jerome. I would appreciate your help with the following problem.
I ahve excel sheet whcih contains data of displayed in various levels. There
are 11 levels in total. However exch level has different categories. I have
to add the values of level 2 in level 1 and all the values of level 3 into 2
and so forth. See tteh format below.

You'll notice that I have to add (PAYMENTS, TRANSFERS AND SUBSIDIES,
PAYMENTS FOR CAPITAL ASSETS - which are in level 2 ) in level 1 (PAYMENTS)

I should do teh same for (TAX RECEIPTS, SALES GOODS & SERV NON CAP ASS,
TRANSFERS RECEIVED, FINES, PENALTIES AND FORFEITS, INTEREST, DIVIDEND, RENT
ON LAND, SALES OF CAPITAL ASSETS) and add it in level 1 (RECEIPTS)

LEVEL CODE AMOUNT 1 2
1 96623 PAYMENTS
2 982623 PAYMENTS
2 988623 TRANSFERS AND SUBSIDIES
2 996623 PAYMENTS FOR CAPITAL ASSETS
1 6318623 DIRECT EXCHEQUER PAYMENTS
2 6319623 DIRECT EXCHEQUER PAYMENTS
1 1623 RECEIPTS
2 2623 TAX RECEIPTS
2 3623 SALES GOODS & SERV NON CAP ASS
2 40623 TRANSFERS RECEIVED:
2 65623 FINES, PENALTIES AND FORFEITS
2 72623 INTEREST, DIVIDEND, RENT ON LAND
2 102623 SALES OF CAPITAL ASSETS

I have to do thsi for the entire worksheet. Could you please advise me how I
should go about this.

Thank you very much!:O)

Best regards,

Jerome