How do i count Text in the Cells, but not formulas.
 

In column A:A
I have names, but these names are a result of a formula.. When I use counta
it counts the names plus the "blank" rows that fallow which contain a
formula.

How can i have it count only names not formulas.

Thanx in advance.

How do i count Text in the Cells, but not formulas.
 

=COUNTIF(A1:A10,"''")

"Jman" wrote:


In column A:A
I have names, but these names are a result of a formula.. When I use counta
it counts the names plus the "blank" rows that fallow which contain a
formula.

How can i have it count only names not formulas.

Thanx in advance.

How do i count Text in the Cells, but not formulas.
 

For some odd reason i am getting a "0" after i enter the formula, yet i have
about 23 names it that column.

"Mike" wrote:

=COUNTIF(A1:A10,"''")

"Jman" wrote:


In column A:A
I have names, but these names are a result of a formula.. When I use counta
it counts the names plus the "blank" rows that fallow which contain a
formula.

How can i have it count only names not formulas.

Thanx in advance.

How do i count Text in the Cells, but not formulas.
 

Ok it works.. it was missing the third quotation mark at the end. """)

Thanks much...

"Mike" wrote:

=COUNTIF(A1:A10,"''")

"Jman" wrote:


In column A:A
I have names, but these names are a result of a formula.. When I use counta
it counts the names plus the "blank" rows that fallow which contain a
formula.

How can i have it count only names not formulas.

Thanx in advance.