Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding up different combos of columns
I have three columns of account code names.
The first column (A) contains the main codes names. The 2nd column (B) contains sub codes The 3rd column (C) contains sub codes of B. What I need to is be able to calcuate year-to-date of any combination expeness that were coded to any combination of A, B, C. All expenses are assigned a code from each column - in any combination. So I need to calculate totals for each combination. At the start of each fiscal year, code names may be changed, deleted or more added. For example potential codes under each column: Column A Supplies Auto Dining Out Repairs Training Column B Office Plant Students Column C Marketing Sales Finance So I need to know what expenses fell in the combination of Supplies (A), Office (B), Marketing (C) and, Supplies (A), Plant (B), Sales (C) and Auto (A), Office (B), Marketing (C) etc.... Any ideas of how best to do this...much thx |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding up different combos of columns
You could use a pivot table to summarize the data, and with the account
codes in the row area, and the expense amount in the data area. There are instructions and links he http://www.contextures.com/xlPivot01.html samdev wrote: I have three columns of account code names. The first column (A) contains the main codes names. The 2nd column (B) contains sub codes The 3rd column (C) contains sub codes of B. What I need to is be able to calcuate year-to-date of any combination expeness that were coded to any combination of A, B, C. All expenses are assigned a code from each column - in any combination. So I need to calculate totals for each combination. At the start of each fiscal year, code names may be changed, deleted or more added. For example potential codes under each column: Column A Supplies Auto Dining Out Repairs Training Column B Office Plant Students Column C Marketing Sales Finance So I need to know what expenses fell in the combination of Supplies (A), Office (B), Marketing (C) and, Supplies (A), Plant (B), Sales (C) and Auto (A), Office (B), Marketing (C) etc.... Any ideas of how best to do this...much thx -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing two combos/cells to return a value | Excel Worksheet Functions | |||
combos and dates | Excel Programming | |||
Entering combos without converting it to dates? | Excel Discussion (Misc queries) | |||
too many combos | Excel Programming | |||
one sub for many Combos in different way | Excel Programming |