G
Guest
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
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