The SUMPRODUCT versions seem to work for me......but of course in Excel 2010 you can also use COUNTIFS
=COUNTIFS(F2:F24,">27",F3:F25,">27")>0
The SUMPRODUCT versions seem to work for me......but of course in Excel 2010 you can also use COUNTIFS
=COUNTIFS(F2:F24,">27",F3:F25,">27")>0
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks