Can you sort the data on the Account column then use DataSubtotals to return
the totals for each unique account number?

Results won't be in F2, F3, F4 unless you use those to refer to the subtotal
cells.


Gord Dibben MS Excel MVP

On Sat, 22 Jul 2006 14:54:02 -0700, jk wrote:

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