Hi Pascal,![]()
As you no doubt know, I'm not stellar at formulas, but I think this actually works.![]()
Where MyRange refers to:Formula:=Sheet1!$C$7:$C$9I 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+)=SUMPRODUCT(--ISERROR(MATCH(A1:A5,MyRange,0)),B1:B5)
Hope this helps?
Mark