Thread: IF formula returns TRUE instead of evaluating COUNTIF
View Single Post
 
Old 12-28-2011, 03:24 AM
ColinC ColinC is offline Windows 7 64bit Office 2010 64bit
Novice
  
Join Date: Dec 2011
Location: England
Posts: 9
ColinC is on a distinguished road
Default IF formula returns TRUE instead of evaluating COUNTIF
=IF((COUNTBLANK(A22:Y22))=0,"=COUNTIF(A22:Y22,">"& E22)","")

The above formula is intended to check whether a row (A22:Y22) is complete.
If all cells filled, return the number exceeding the reference cell E22.
If there are blank cells, return empty cell.
The above formula returns TRUE and does not evaluate the COUNTIF formula which works correctly in isolation.
Help please.
Reply With Quote