WHat is wrong with this formula
 

=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.

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.

WHat is wrong with this formula
 

You can't form the address in this manner. Excel is trying to pass the
result of the Match function as an argument to the function '11th game'!B.
Try instead =if(index('11th game'!B:B,match( ... )+19) = ...

"Sportinus" wrote:

=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.