I have two tabs. One tab has a list of identifiers and value next to it. There are duplicate identifiers. I'm looking to populate the values into tab 2 but I want to add up the values and so that Tab 2 reflects one identifier and one total value. I typically used something along the lines of =SUM((Sheet2!E$11:E$214)*C9(Sheet2!J$11:J$214)) Where C9 starts the single list of identifiers on Tab 2.

This formula doesn't seem to work. I'm a little rusty. Can anyone help?