CountA excluding 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.
 
R

Ronx

You should ask this question in a forum or newsgroup that deals with the
spreadsheet you are using - FrontPage is a web site editing application.
 

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

Similar Threads

How do i count Text in the Cells, but not formulas. 3
Excel - Wich Function should I use? 1
COUNTIF + ADDRESS Issue 1
Copy addition formula of non-consecutive horizontal cells 2
Count Non-Empty Cells In Each Row 0
Count Values in a Range, Not Formulas 2
Count Number of Unique Cells That Don't Have Certain Characters 0
Problems with count, counta and countifs 6

Top