Thread: Excel formla
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
  
Posts: 10,593
Default Excel formla
=COUNTA(A1:A20)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Forgetfulpgk" wrote in message
...
What is the formula for counting the number of cells containing ANY
text?


Reply With QuoteReply With Quote