Thread: Sum of values
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jk jk is offline
external usenet poster
 
Posts: 109
Default Sum of values

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?