Sum on Account
 

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

Sum on Account
 

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

Sum on Account
 

You could also use a Pivot Table.


--
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

Sum on Account
 

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