On 18 Mar, 09:47, joeu2004 wrote:
On Mar 18, 12:37*am, Scossa wrote:

i found that this operator "" in a function like CountIf()
=CountIf( A1:A30, "")
returns the numbures of cells that contain text.

But unlike others operators, if you try somthing like
*=A1A3 yuo can't close edit.

You are misinterpreting the COUNTIF parameter, understandably.

The first "" is the comparison operator. *The second "" is the
character "".

So COUNTIF(A1:A30,"") counts all cells will text whose strings
compare greater than "".

You can replace the second "" with other characters (e.g. ":") and
get the same result.

You can see things as COUNTIF does by putting =A1"" into B1 and copy
down through B30.

What I do find odd is that ="2""" returns TRUE. *The ASCII code for
"2" is 50, and the ASCII code for "" is 62.

OK, tnks, the correct explanation is often the simplest.

Bye!
Scossa