View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jman Jman is offline
external usenet poster
 
Posts: 110
Default 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.