Thread: Exclude certain text from =COUNTA
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
  
Posts: 1,766
Default Exclude certain text from =COUNTA
Hi,

Try this

=COUNTIF(C11:C16,"<~*")

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Alice M." wrote in message
...
Since I cannot figure out how to have =COUNTA exclude text in hidden rows,
how do I write a formula using =COUNTIF that would exclude any location
containing an asterisk?

Reply With QuoteReply With Quote