View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Joshua Joshua is offline
external usenet poster
 
Posts: 1
Default 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