Just to extend it a little further ..

If we want to count the number of numbers within cols A to F (in row2 down)
which match the reference set of numbers in G1:L1 (eg: as in checking lotto
tickets against results)

we could put in say, M2:
=SUMPRODUCT(--ISNUMBER(MATCH(A2:F2,G$1:L$1,0)))
and copy M2 down to return the counts

[The numbers in cols A to F, and those in the reference set
can be in any order, need not be sorted]
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---