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

J

Jman

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.
 
J

Jman

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top