Greetings,

In the attached file, I like to compare the LIST in cell A against cell C and if there is a match, I want to take the number from COUNT column (cell D), copy into column B, and add them to get one total. What is the best way to accomplish this?

Paste this into cell B2 and drag it down to B12

{=SUM(IF($C$2:$C$12=A2,$D$2:$D$12),0)}

Hope this is what you wanted
Mike

Howdy. What about near matches? I.e. in column A you have "A & T " (which has two spaces at the end, as well as spaces between characters) and in Column C you have "A&T " (one space at the end, and no spaces between characters).

This will affect your data integrity and results.