Hi Jerome,
Was wondering why there really wasn't any data, then it occurred to me
that this must be a class work problem. Take a look at Data, Subtotals
that is from the menus.
You can probably find a video tutorial at
http://www.datapigtechnologies.com/ExcelMain.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"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