2 files, one worksheet

In 2 files, Column A, I have 30 names repeated 20 times. Column B has a
number value associated with each name, some cell will be zero. I do not
want to sort this list; it will have budget dollars associated with it.

The worksheet in one of the files has only 30 names on it in Column A. I
need a formula in Column B that looks for all occurrences of "John Doe" and
returns a total value associated with "John Doe".

Can anyone help me?