#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
in the IF function, for Value if true, you should have
COUNTIF(A22:Y22,">"& E22) not "=COUNTIF(A22:Y22,">"& E22)" |
#3
|
||||
|
||||
Quote:
__________________
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
|
|||
|
|||
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
|
|||
|
|||
To CATALIN.B
Thank you. exactly what I wanted. COLIN. |
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 |
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 |