Excel to Numbers INDIRECT formula help needed

[Nukks]

So I'm moving a spreadsheet from excel to numbers and I'm having an issue with one of the indirect formula's. I'm not really sure where to find or correct the error.

The excel formula is:
=IF(COUNTIF(INDIRECT("Week"&ROW()-2&"!$N$24:$N$39"),C$1)=0,"",COUNTIF(INDIRECT("Week"&ROW()-2&"!$N$24:$N$39"),C$1))

When I import this into Numbers I get the following error message for that
"The formula couldn't be imported. The function INDIRECT might have produced a different result than in Excel. The formula was replaced by the last calculated value.

 

[Cory Cooper]

Hello and welcome,

-Which version of OS X?
-Which version of Excel?
-Which version of Numbers?
-Are you copying and pasting the formula, or did you simply open the spreadsheet in Numbers directly?

C

 

[Nukks]

Thanks for responding. I was able to adjust.