Exclude certain text from =COUNTA

[Alice M.]

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?

 

[RagDyer]

Try this:

=COUNTIF(A1:A10,"<>*~**")

 

[Ashish Mathur]

Hi,

Try this

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

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com