On Fri, 18 Mar 2011 00:37:46 -0700 (PDT), Scossa wrote:

Hello,

I' apologize for my bad english......

Everyone know logical operator "=", "", "<", "=", "<=", but 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.

I haven't found nothing in on-line Excel documentation about this.

Ideas???

Bye!
Scossa

I do not believe that "" is an operator. Rather it means <greater than <the greater than sign

In other words, the first character is the operator; the second character is the operand.

If you enter a series of characters in column A, and then in column B enter

=A1 ""

and fill down, you will see that anything that evaluates to TRUE will be counted by your COUNTIF expression.