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
|