Just a further thought .. if there's the possibility of the source winning
numbers and/or picked numbers being either "text-entered" -- ie numbers
entered with a preceding apostrophe, or entered into cells pre-formatted as
text (the pre-formatting as text unknown to you, of course), then use this
slightly tweaked version instead:
=SUMPRODUCT(--ISNUMBER(MATCH(B1:G1+0,Sheet1!$A$1:$F$1+0,0)))
The "+0" to both source ranges will coerce the text numbers (if any) to real
numbers for correct results.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---