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