=IF(ISNONTEXT(Sheet1!C2),(A5=A5+1),(A5=1))

F

famdamly

Weird, when I put text in the queried field it returns true, and vis
versa for ISTEXT, I must not understand the logic of that
 
R

Ron Rosenfeld

Weird, when I put text in the queried field it returns true, and vise
versa for ISTEXT, I must not understand the logic of that.
Click to expand...

=IF(ISNONTEXT(C2),A5=A5+1,A5=1)

Makes perfect sense if A5 contains a 1.

Your formula says to execute either:
A5=A5+1
or
A5=1

depending on the result of your logical test.

A5=A5+1 must always be FALSE.

A5=1 will be True if there is a '1' in A5.


--ron
 
Top