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