IF formula returns TRUE instead of evaluating COUNTIF

		Microsoft Office Forums > Microsoft Excel > Excel
IF formula returns TRUE instead of evaluating COUNTIF

FAQ

Thread Tools

Display Modes

12-28-2011, 03:24 AM

ColinC

Windows 7 64bit IF formula returns TRUE instead of evaluating COUNTIF

Office 2010 64bit

Novice

Join Date: Dec 2011

Location: England

Posts: 9

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.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
COUNTIF and Cell address problem	ColinC	Excel	3	12-24-2011 04:08 AM
using a cell content as a string with COUNTIF	geoffm	Excel	1	08-16-2011 11:31 AM
Countif with 2 criteria	ibrahimaa	Excel	3	05-23-2011 11:23 AM
Macro not staying true	oluc	Word VBA	4	11-21-2010 08:10 AM
evaluating a text expression in a form field	gwp1	Word	0	10-08-2007 02:15 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:48 AM.