Sheeloo,

thanks for you suggestions so far, but unfortuantely that way requires me to
use another column again to do interim memory value storage, which is what
I'm trying to avoid.

Basically, what I would like to have happen is, if in your example;

=SUMPRODUCT(--(Sheet2!A1:A100=A1),(Sheet2!B1:B100))

Sheet2!A1:A100=A1 could be replaced with Sheet2!A1:A100=Sheet1!A1:A60 and
have it work for the entire range.

"Sheeloo" wrote:

Assuming you have a name in A1 of Sheet1 then enter this in Z1 of Sheet1

=SUMPRODUCT(--(Sheet2!A1:A100=A1),(Sheet2!B1:B100))

You can copy this formula down

You can sum up col B if you want to get the sum for all names in Sheet1