IF formula returns TRUE instead of evaluating COUNTIF

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

12-28-2011, 05:02 AM

Catalin.B

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

in the IF function, for Value if true, you should have
COUNTIF(A22:Y22,">"& E22) not

"=COUNTIF(A22:Y22,">"& E22)"

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 09:29 PM.