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

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

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