ExcelBanter - Exclude certain text from =COUNTA

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Exclude certain text from =COUNTA (https://www.excelbanter.com/excel-worksheet-functions/238793-exclude-certain-text-%3Dcounta.html)

Alice M.

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?

RagDyeR

Exclude certain text from =COUNTA

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?

Ashish Mathur[_2_]

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?

All times are GMT +1. The time now is 02:34 AM.