View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.setup
Franz Verga Franz Verga is offline
external usenet poster
 
Posts: 459
Default Accumulate values

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?


You can use the SUMIF function. Check on online help...

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy