Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-28-2011, 03:24 AM
ColinC ColinC is offline IF formula returns  TRUE  instead of evaluating  COUNTIF Windows 7 64bit IF formula returns  TRUE  instead of evaluating  COUNTIF Office 2010 64bit
Novice
IF formula returns  TRUE  instead of evaluating  COUNTIF
 
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
  #2  
Old 12-28-2011, 05:02 AM
Catalin.B Catalin.B is offline IF formula returns  TRUE  instead of evaluating  COUNTIF Windows Vista IF formula returns  TRUE  instead of evaluating  COUNTIF Office 2010 32bit
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

in the IF function, for Value if true, you should have
COUNTIF(A22:Y22,">"& E22) not
"=COUNTIF(A22:Y22,">"& E22)"
Reply With Quote
  #3  
Old 12-28-2011, 06:04 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline IF formula returns  TRUE  instead of evaluating  COUNTIF Windows XP IF formula returns  TRUE  instead of evaluating  COUNTIF Office 2003
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #4  
Old 12-28-2011, 08:15 AM
ColinC ColinC is offline IF formula returns  TRUE  instead of evaluating  COUNTIF Windows 7 64bit IF formula returns  TRUE  instead of evaluating  COUNTIF Office 2010 64bit
Novice
IF formula returns  TRUE  instead of evaluating  COUNTIF
 
Join Date: Dec 2011
Location: England
Posts: 9
ColinC is on a distinguished road
Default

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.
Reply With Quote
  #5  
Old 12-28-2011, 08:21 AM
ColinC ColinC is offline IF formula returns  TRUE  instead of evaluating  COUNTIF Windows 7 64bit IF formula returns  TRUE  instead of evaluating  COUNTIF Office 2010 64bit
Novice
IF formula returns  TRUE  instead of evaluating  COUNTIF
 
Join Date: Dec 2011
Location: England
Posts: 9
ColinC is on a distinguished road
Default

To CATALIN.B
Thank you. exactly what I wanted.
COLIN.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
COUNTIF and Cell address problem ColinC Excel 3 12-24-2011 04:08 AM
IF formula returns  TRUE  instead of evaluating  COUNTIF using a cell content as a string with COUNTIF geoffm Excel 1 08-16-2011 11:31 AM
IF formula returns  TRUE  instead of evaluating  COUNTIF Countif with 2 criteria ibrahimaa Excel 3 05-23-2011 11:23 AM
IF formula returns  TRUE  instead of evaluating  COUNTIF 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 04:44 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft