Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
summing multiple lines throughout spreadsheet
Hello,
I was wondering if anyone could help. I have a 15000 lines spreadsheet with different product codes on them. I need to take all matching product codes and sum the total price of them. I was wondering if there was an easy way to do this. In example below I have three groups and basically I need a row added and a total line made but I have about 300 different groups to sum. Can anyone help? if this does not make any sense let me know. Example: 1 10 1 12 1 14 2 20 2 12 2 13 2 15 3 11 3 9 3 8 3 9 3 12 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
summing multiple lines throughout spreadsheet
Joshua,
Use a Pivot Table - add the product code to the row area, and the price to the data area. HTH, Bernie MS Excel MVP "Joshua" wrote in message ... Hello, I was wondering if anyone could help. I have a 15000 lines spreadsheet with different product codes on them. I need to take all matching product codes and sum the total price of them. I was wondering if there was an easy way to do this. In example below I have three groups and basically I need a row added and a total line made but I have about 300 different groups to sum. Can anyone help? if this does not make any sense let me know. Example: 1 10 1 12 1 14 2 20 2 12 2 13 2 15 3 11 3 9 3 8 3 9 3 12 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
summing multiple lines throughout spreadsheet
Hi,
you can also use Data Subtotal. First sort the codes in ascending order (so that same produce codes appear together), then select the range and go to Data Subtotal -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Joshua" wrote in message ... Hello, I was wondering if anyone could help. I have a 15000 lines spreadsheet with different product codes on them. I need to take all matching product codes and sum the total price of them. I was wondering if there was an easy way to do this. In example below I have three groups and basically I need a row added and a total line made but I have about 300 different groups to sum. Can anyone help? if this does not make any sense let me know. Example: 1 10 1 12 1 14 2 20 2 12 2 13 2 15 3 11 3 9 3 8 3 9 3 12 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Worksheets, multiple lines and summarizing into one works | New Users to Excel | |||
In Excel 2007 chart with multiple lines, mouse doesn't track lines | Charts and Charting in Excel | |||
summing multiples lines in a vlookup function | Excel Worksheet Functions | |||
display 1 line of multiple worksheets into multiple lines on 1 wks | Excel Worksheet Functions | |||
Display multiple lines of text within a cell from multiple column. | Excel Worksheet Functions |