Try this:

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"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?