Can anyone translate this to a formula that can work with older versions of excel?
XXXXXX
-------------------------------------------------------------------
CANCEL THAT. I need this one to work with Excel 2000. .
=SUMPRODUCT(COUNTIF(INDIRECT({"E15","E20","E25","E30"}),">84.5"))
Bookmarks