I do not understand your 'levels'. Tell us how the data is set out: column
A as level-number 1 to 12? Column B has amount, and C has item name?
What you want to add?
All Level 1 Payments, all level 2 payments - as 2 separate numbers or 1 ?


--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Jerome" wrote in message
...
Hi there,

My name is Jerome. I would appreciate your help with the following
problem.
I have an excel sheet whcih contains data displayed in various levels.
There
are 11 levels in total. There are over 5000 rows. However each 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 the 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 this for the entire worksheet. Could you please advise me how
I
should go about this.

Thank you very much!:O)

Best regards,

Jerome