Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum Individual Account Balances
I have been working on this all morning and I can't seem to get it...
I want to get a single total for each account number when my data has a random distribution of accounts for example: Account Balance Total Owed (what I want/can't figure out) A100 1 1 A101 2 A101 1 3 A102 3 3 A103 2 2 A104 2 2 A105 3 A105 3 A105 4 10 I haven't been able to combine a logic function with a nested sum to make this happen, Any ideas? Brendan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can a service account be embedded in Workbook so that by default the macros are run with service account credentials and not the user credentials??? | Excel Discussion (Misc queries) | |||
Running Balances | Excel Discussion (Misc queries) | |||
Calculate and display individual error bars for individual points | Charts and Charting in Excel | |||
Calculate and display individual error bars for individual points | Charts and Charting in Excel | |||
How to link endings balances to beginning balances on different sh | Excel Worksheet Functions |