With the Account number in A1:A9 and the Balances in B1:B9, in C1
=SUMPRODUCT(($A$1:$A$9=A1)*($B$1:$B$9)) and drag down to C9
Regards,
Alan.
"Brendan Hanrahan" wrote in message
...
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