View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RHS RHS is offline
external usenet poster
 
Posts: 1
Default subtotalling a list to another cell

I have a cloumn of values beside a column of codes. in another worksheet I
want to have the sum of all of those values with the same code in a subtotal
eg
code Value
123 100.00
423 50.00
123 75.00
230 80.00

In a list on another worksheet in the cell next to the value 123 I would
like the result 175.00, 423 - 50.00 and 230 - 80.00