I have a column with a list of names and a table with those same names
repeated many times with a value from one to five in the column next to them.
I need a formula that will first determine if a name in my list matches the
name in the table, and then tally the number of times the value "1" occurs.

It seems like I should be using a COUNTIF and some sort of lookup table, but
I can't seem to get it right. Can anyone help?