See the SUMIF function.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"jk" wrote in message
...
I need to obtain sum totals from ten different acount numbers in
column A
which have dollar amounts in the column B.There are many
duplicate entries of
any account and i would like to tie a value to a cell which
would accumulate
the sum for each account entered in column A?Example:
Acct
10012 $150.00 cell F2 =sum of 10012 (the sum would be
$200)
10014 $100.00 cell f3 =sum of acct 10014
10012 $50.00 cell f4= sum of acct 10015
10015 $40.00