C1: =A1
C2: =IF(ISERROR(MATCH(0,COUNTIF(C$1:C1,$A$1:$A$20&""), 0)),"",
INDEX(IF(ISBLANK($A$1:$A$20),"",$A$1:$A$20),MATCH( 0,COUNTIF(C$1:C1,$A$1:$A$2
0&""),0)))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

Copy C2 down as far as you need

D1: =SUMIF(A:A,C1,B:B)

and copy down

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"jk" wrote in message
...
I have column A that contains many account numbers and i have column B
which
is a dollar value that corresponds to each account.

A B
10023 $25.00
10024 $20.00
10025 $25.00
10023 $25.00
10026 $25.00
Is it possible to assign cells in column C to sum the amounts which equal
the accounts. For example account 10023 sums up to $50.00 and i would like
each time the account of 10023 is entered into column A ,it would
accumulate
the amount in a cell of column C .........can this be done?