Sum Individual Account Balances
This would be a perfect situation for a pivot table.
Highlight all your data... click on Data--Pivot Table from the menu bar
There just follow the instructions. Put your accounts in the row heading and
the total owed in the data section... and magically it creates what you want.
"Brendan Hanrahan" wrote:
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
|