I have the following formula that works in excel 2007 but need it to function in 2003...and have no idea where to start...

=IF(A4="", " ", (COUNTIFS('Chem Log'!$C:$C,A4,'Chem Log'!$J:$J,$C$1)))


A4 = Chemical Name
'Chem Log'!$C:$C = Column where all chemical names listed
'Chem Log'!$J:$J = Column where the status of chemicals are
$C$1 = the specific status that looking for such as "Opened"

if anyone can help or suggest an alternative to the COUNTIFS function it would be great.

Thanks
Michael