Countif statement from Excel to Calc

New to LibreOffice from Excel. I uses the below formula to see if the numbers on one sheet are in the other and then give a true or false statement. This is written in Excel. Can some one help me with converting it to LibreOffice Calc please?

=IF(COUNTIF(Sheet2!$A$1:$AK$99, E1)>0, TRUE,FALSE)


Try =IF(COUNTIF(Sheet2.A$1:$AK$99, E1)>0, TRUE,FALSE)

That works, Thanks