Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
account # entry needs to return the account description | Excel Worksheet Functions | |||
Margin Account | New Users to Excel | |||
Can a service account be embedded in Workbook so that by default the macros are run with service account credentials and not the user credentials??? | Excel Discussion (Misc queries) | |||
bank account | Excel Programming |