A job for SP?

[GTO]

Hi Pascal,

As you no doubt know, I'm not stellar at formulas, but I think this actually works.

Where MyRange refers to:

=Sheet1!$C$7:$C$9

Formula:

=SUMPRODUCT(--ISERROR(MATCH(A1:A5,MyRange,0)),B1:B5)

I would add that in C7:C9, I entered the subjects' first and last names, as I guessed that the omitting of last names was unintentional? (At home currently, so I went by the picture, as I cannot see/open 2007+)

Hope this helps?

Mark