Match numbers

[Yippy_Kiyey]

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*
2	*	Winning Lotto Numbers					*	*	My Numbers					*	*	Matched
3	*	1	2	3	4	5	7	*	4	17	33	47	50	7	*	1	Plus	1
4	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*
5	*	Count the number of "matches" between Winning Lotto numbers and My Numbers	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*
Sheet1

I want to shorten my formula on P3. Please advice

 

[T. Valko]

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*
2	*	Winning Lotto Numbers					*	*	My Numbers					*	*	Matched
3	*	1	2	3	4	5	7	*	4	17	33	47	50	7	*	1	Plus	1
4	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*
5	*	Count the number of "matches" between Winning Lotto numbers and My Numbers	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*
Sheet1

I want to shorten my formula on P3. Please advice

One way...

Entered in P3:

=SUMPRODUCT(--(ISNUMBER(MATCH(B3:F3,I3:M3,0))))