Countif cells are beings with "*"
 

Excel 2000. I need to count when cell in column C beings with marker "*".
Column C comprises of cells with numberic, text & cells with number but
marked with "*". I have used =Countif(C1:C100,"*") however results show that
formula counted even text cells.

How do I restrict the count to cells marked with "*" ? I have tried adding
a tilde (~) before the character, as what some writeup advise. But it still
didn't work.

Countif cells are beings with "*"
 

=COUNTIF(C1:C100, "~**) two asterisks

One for the wildcard and one for the asterisk to find.


Gord Dibben MS Excel MVP

On Wed, 13 Jun 2007 17:11:02 -0700, summer
wrote:

Excel 2000. I need to count when cell in column C beings with marker "*".
Column C comprises of cells with numberic, text & cells with number but
marked with "*". I have used =Countif(C1:C100,"*") however results show that
formula counted even text cells.

How do I restrict the count to cells marked with "*" ? I have tried adding
a tilde (~) before the character, as what some writeup advise. But it still
didn't work.

Countif cells are beings with "*"
 

Thanks. It works.

"Gord Dibben" wrote:

=COUNTIF(C1:C100, "~**) two asterisks

One for the wildcard and one for the asterisk to find.


Gord Dibben MS Excel MVP

On Wed, 13 Jun 2007 17:11:02 -0700, summer
wrote:

Excel 2000. I need to count when cell in column C beings with marker "*".
Column C comprises of cells with numberic, text & cells with number but
marked with "*". I have used =Countif(C1:C100,"*") however results show that
formula counted even text cells.

How do I restrict the count to cells marked with "*" ? I have tried adding
a tilde (~) before the character, as what some writeup advise. But it still
didn't work.