WHat is wrong with this formula
Try it this way:
=IF(INDIRECT("'11th game'!B"&MATCH(A2,'11th
game'!B20:B34,0)+19)=Sheet1!A2,COUNTIF('11th game'!C25:N25,Sheet1!C1),"")
Hope this helps.
Pete
"Sportinus" wrote in message
...
=IF('11th game'!B(MATCH(A2,'11th
game'!B20:B34,0)+19)=Sheet1!A2,COUNTIF('11th
game'!C25:N25,Sheet1!C1),)
11th game is a worksheet name. Excel does not like '11th game'!B The
MATCH returns what I expect. Any help is appreciated.
|