Microsoft Office Forums IF formula returns TRUE instead of evaluating COUNTIF
 Register FAQ Search Today's Posts Mark Forums Read

#1
12-28-2011, 03:24 AM
 ColinC Windows 7 64bit 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.
#2
12-28-2011, 05:02 AM
 Catalin.B Windows Vista Office 2010 32bit Expert Join Date: May 2011 Location: Iaşi, Romānia Posts: 386

in the IF function, for Value if true, you should have
COUNTIF(A22:Y22,">"& E22) not
"=COUNTIF(A22:Y22,">"& E22)"
#3
12-28-2011, 06:04 AM
 Pecoflyer Windows XP Office 2003 Expert Join Date: Nov 2011 Location: Brussels Belgium Posts: 2,507

Quote:
 return the number exceeding the reference cell E22
What do you mean?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
#4
12-28-2011, 08:15 AM
 ColinC Windows 7 64bit Office 2010 64bit Novice Join Date: Dec 2011 Location: England Posts: 9

To PECOFLYER
Thankyou for your interest in my post. Sorry about the lack of clarity in the question. I meant in the range A22:Y22 return the number of cells with a value greater than the value in E22.
The problem has now been solved but thanks anyway.
#5
12-28-2011, 08:21 AM
 ColinC Windows 7 64bit Office 2010 64bit Novice Join Date: Dec 2011 Location: England Posts: 9

To CATALIN.B
Thank you. exactly what I wanted.
COLIN.

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post ColinC Excel 3 12-24-2011 04:08 AM geoffm Excel 1 08-16-2011 11:31 AM ibrahimaa Excel 3 05-23-2011 11:23 AM oluc Word VBA 4 11-21-2010 08:10 AM gwp1 Word 0 10-08-2007 02:15 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:23 PM.

 -- Default Style -- Lightweight -- New Mobile Contact Us - Privacy Statement - Top