Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Too many levels in the IF function? | Excel Discussion (Misc queries) | |||
sum sub levels. | Excel Discussion (Misc queries) | |||
sum sub levels. | Excel Worksheet Functions | |||
sum sub levels. | New Users to Excel | |||
linking 3 levels | Excel Programming |