Match formula question?

  • Thread starter Thread starter Michael168
  • Start date Start date
M

Michael168

Can the below formula be shorten by using "Match"?


Formula=COUNTIF(J2:P2,"=1")+COUNTIF(J2:P2,"=7")+COUNTIF(J2:P2,"=11")+COUNTIF(J2:P2,"=17")+COUNTIF(J2:P2,"=21")+COUNTIF(J2:P2,"=27")

Thanks for helping.

Michael16
 
=SUMPRODUCT(--ISNUMBER(MATCH($J$2:$P$2,{1,7,11,17,21,27},0)))

=SUM(COUNTIF($J$2:$P$2,{1,7,11,17,21,27}))
 
Back
Top