Count cells but omit ones with certain text

[willow1985]

Is there a formula to count all cells but omit ones with certain text?

for example: I want to count all of the cells below but I do not want to count the ones containing the word "Blue"

Yellow
Red
Blue
Green
Yellow
Red
Purple

the result would be: 6

Help with this would be greatly appreciated.

Carla

 

[KOKOSEK]

=COUNTIF(A1:A7,"<>Blue")

?

 

[willow1985]

I there a way to not include blanks as well?, Thank you

 

[Fluff]

ow about
=COUNTIFS(C2:C10,"<>Blue",C2:C10,"?*")

 

[willow1985]

Thank you very much

 

[lezawang]

Can I ask what does "?*" mean? is that how we search for blank cell. Thank you

 

[Fluff]

Thank you very much

You're welcome & thanks for the feedback.

The ?* will count text values

 

[lezawang]

Not include black cells. Sorry I did not read that. Ok I know why now. Thank you