summing multiple lines throughout spreadsheet

  • Thread starter Thread starter Joshua
  • Start date Start date
J

Joshua

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