Not Counting cells that have a formula with ""

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

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

"Steve" wrote:

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 NOT the
blank cells.

Thanks,

Steve

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

Bob Umlas
Excel MVP
("Steve" wrote in message
...
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 wrote...
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 "".

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

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

--
Biff
Microsoft Excel MVP


"Steve" wrote in message
...
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

Wow ! That was fast, and it worked great.
One mo 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

"Bob Umlas" wrote:

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

Bob Umlas
Excel MVP
("Steve" wrote in message
...
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

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

Much thanks,

Steve

"Harlan Grove" wrote:

Steve wrote...
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 "".