=SUMIF(Code_Range,123,Value_Range)


--
Regards,

Peo Sjoblom



"RHS" wrote in message
...
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