Lookup and count from another workbook

[mss_determined]

Looking for a formula that will find a name in column A and add the total form column B. The name will appear more than once in A column. Like below.
I will be pulling this data from a different workbook then the one I will be reporting it in.

Thanks

A B
John 10
Sue 26
Mark 8
Jill 14
John 2
John 35
Pam 79
Sue 12