View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sportinus Sportinus is offline
external usenet poster
 
Posts: 3
Default 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.