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
Bookmarks