| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Brain Dead: Need help with ????
adding a range of numbers within a column based on a corresponding cell. I have two columns, one with account numbers and one with dollar amounts. I've sorted the range so that all account numbers are grouped together. I want Excel to add all the dollar amounts associated with each account. Not sure which formula to use? Any help would be appreciated. Thanks Warren -- WarrenC ------------------------------------------------------------------------ WarrenC's Profile: http://www.excelforum.com/member.php...o&userid=35524 View this thread: http://www.excelforum.com/showthread...hreadid=564550 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Brain Dead: Need help with ????
Hi!
One way to do this is to use Subtotals. Assume column A contains the account numbers and in A1 is the header Account. Column B contains the numeric values an in B1 is the header Amount. Select A1 Goto DataSubtotals Make these selections in the user form: At each change in: Account Use function: Sum Add Subtotal to: Amount OK Biff "WarrenC" wrote in message ... adding a range of numbers within a column based on a corresponding cell. I have two columns, one with account numbers and one with dollar amounts. I've sorted the range so that all account numbers are grouped together. I want Excel to add all the dollar amounts associated with each account. Not sure which formula to use? Any help would be appreciated. Thanks Warren -- WarrenC ------------------------------------------------------------------------ WarrenC's Profile: http://www.excelforum.com/member.php...o&userid=35524 View this thread: http://www.excelforum.com/showthread...hreadid=564550 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Brain Dead: Need help with ????
thanks, I knew there was an easy way -- WarrenC ------------------------------------------------------------------------ WarrenC's Profile: http://www.excelforum.com/member.php...o&userid=35524 View this thread: http://www.excelforum.com/showthread...hreadid=564550 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Brain Dead: Need help with ????
You're welcome!
Biff "WarrenC" wrote in message ... thanks, I knew there was an easy way -- WarrenC ------------------------------------------------------------------------ WarrenC's Profile: http://www.excelforum.com/member.php...o&userid=35524 View this thread: http://www.excelforum.com/showthread...hreadid=564550 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filtering out weekday dead time | Excel Worksheet Functions | |||
| Brain Clog! Help with formula, please | Excel Discussion (Misc queries) | |||
| Subtraction brain block | Excel Discussion (Misc queries) | |||
| This is Weird - Dead Simple Issue with Sum Function | Excel Worksheet Functions | |||
| Counting for two criteria - brain drain | Excel Worksheet Functions | |||
Linear Mode
