Accounts are duplicated in this column since a data entry person keys the
account for the customers purchase's.I want to be able to sum up any account
regardless how many times it appears in the column. It is a way to have
summed results for each account.Does that help to explain?

"WLMPilot" wrote:

Sorry. after reading your request more closely, I see you want to keep track
of ALL accounts. I am not sure how to PULL the accounts from your list
without duplicating. If I figure it out, I will get back with you unless
someone else shows you how.

"jk" wrote:

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?