Thread: How do i count Text in the Cells, but not formulas.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
  
Posts: 3,101
Default 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.
Reply With QuoteReply With Quote