I have this formula:
=SUMPRODUCT(--ISNUMBER(MATCH($AR$5:$BC$5,C$271,0)*MATCH($JR$6:$JR$143,$A273,0)*MATCH($JQ$6:$JQ$143,$A$269,0)),$AR$6:$BC$143)
Cell $A$269 just has the number 1 in it.
But I want to change $A$269 in the formula to just be equal to the number instead, so that I don't have to reference a cell there.
I tried:
=SUMPRODUCT(--ISNUMBER(MATCH($AR$5:$BC$5,C$271,0)*MATCH($JR$6:$JR$143,$A273,0)*MATCH($JQ$6:$JQ$143,1,0)),$AR$6:$BC$143)
and
=SUMPRODUCT(--ISNUMBER(MATCH($AR$5:$BC$5,C$271,0)*MATCH($JR$6:$JR$143,$A273,0)*MATCH($JQ$6:$JQ$143,"1",0)),$AR$6:$BC$143)
But neither option works...what's going on here?
Thanks!
Bookmarks