Help! Formulas cannot be read by MS Excel 2002

Hello guys,

need help again.. I have the following formulas below that cannot be read by MS excel 2002.. Hope you guys can help out how to cenvert these formulas applicable to 2002.

=IF(ISNA(VLOOKUP(D17,'SUN GL_BPI Extract'!$A$6:$B$59645,2,FALSE)),"*",VLOOKUP(D17,'SUN GL_BPI Extract'!$A$6:$B$59645,2,FALSE))


=IF(ISNA($E12),"CHECK SUN - POSSIBLE INCORRECT UPDATE",IF(ISNUMBER(SEARCH("void",$E12)),"VOID",IF(IFERROR(MATCH($D12,'Post dated Checks'!$B:$B,0)>0,FALSE),"POSTDATED",IF(ISNA(VLOOKUP($D:$D,'Bank Data'!$A:$F,6,0)),"OUTSTANDING",(VLOOKUP($D:$D,'Bank Data'!$A:$F,6,0))))))

=COUNTIFS('Check Log'!$B:$B,'WEEKLY SUMMARY'!$B9,'Check Log'!$H:$H,'WEEKLY SUMMARY'!E$5)

=IF(ISERROR(WEEKNUM(C7)),B6,WEEKNUM(C7))



Thanks in advance! ^_^

Originally Posted by Jacc

COUNTIFS was not available in 2002.

http://www.excelforum.com/excel-prog...ternative.html

Thanks Jacc! Countifs problem now solved..