Not Counting cells that have a formula with ""

[Steve]

I have a column of cells with a formulas that have
=If(c4 >0, "test", ""). This is the simple form, as there is a few if and
countifs that can produce differnt results, like test, testing, testicle.
How can I count only the cells that have someting in them, basically the
blank cells.

Thanks,

Steve

 

[Steve]

That should be "... basically NOT the blank cells."

 

[Bob Umlas]

=SUMPRODUCT(N(LEN(A1:A100)>0))

Bob Umlas
Excel MVP

 

[Harlan Grove]

I have a column of cells with a formulas that have
=If(c4 >0, "test", ""). This is the simple form, as there is a few if and
countifs that can produce differnt results, like test, testing, testicle.
How can I count only the cells that have someting in them, basically the
blank cells.

The 'blank' cells? Do you mean the NONblank cells?

=COUNTIF(range,"?*")

to count only text strings, or

=COUNTIF(range,"?*")+COUNT(range)

to count nonblank text strings and numbers, or

=ROWS(range)*COLUMNS(range)-COUNTBLANK(range)

to count nonblank cells evaluating to anything other than "".

 

[T. Valko]

This will count all *TEXT* entries in the range and will *exclude* cells
that contain formula blanks:

=COUNTIF(B:B,"?*")

 

[Steve]

Wow ! That was fast, and it worked great.
One more: same situation in a differnt range, with formulas in the cells,
producing either test, or various other text. How do I count the # of cells
that do not have test in them ?

Thanks agai,

Steve

 

[Steve]

Yes, I did mean non-blank. And each of your solutions work great.

Much thanks,

Steve