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