Sum on Account

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Can you sort the data on the Account column then use Data>Subtotals 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum of values 7
Sumproduct forumla for complex sum. 16
Trying to create a conditional sum 2
Sum of Columns 3
Need help with lookup & sum range 2
Formula autofill to cells below – formula arguments are cell areas in different columns 1
Absolute value 3
Search for multiple cells with a row for matching criteria, then sum up certain column 3

Back
Top