Thread: Exclude certain text from =COUNTA
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alice M. Alice M. is offline
external usenet poster
  
Posts: 11
Default Exclude certain text from =COUNTA
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