Hi, I am having trouble figuring out how to combine SUMIF and VLOOKUP. I have a large table with a list of names in column A, then various numbers and statistics associated with each name in the remaining columns. I want to add the numbers in a couple of columns, but only for some of the names in column A. The logic I'm trying to use is to sum the number in column B if the name in column A appears in a list on a different sheet.
Example:
A - B - C
Allen - 10 - 14
Bob - 15 - 12
Charlie - 18 - 13
David - 3 - 42
Edward - 19 - 3
Frank - 2 - 20
Second sheet list:
Bob
Charlie
Frank
So I would like to create a forumula that will sum the numbers in column B if the name in column A shows up in the smaller list. If it worked correctly, the formula would add only column B's values for Bob, Charlie, and Frank for a total of 35. How do I go about this?
-Tom
Bookmarks