Count ifs

[asaf27064]

Hello
i have a list like thisthe list is an example)
yellow frog
green frog
frog
frog
special frog
frog with eyes
brown frog with eyes
frog with eyes
no frog with eyes

i want to use countifs to count all the cells with the word frog but if there is the word eyes in the cell dont count it
the value the need to be its 5
because the list has 9 frog but 4 are with the word "eyes" so its 5.
please help me!
Thanks

 

[Jonmo1]

Re: Count ifs help!

Are those all one cell? "yellow frog" is in one single cell ?

Try
=COUNTIFS(A1:A100,"*frog*",A1:A100,"<>*eyes*")

 

[asaf27064]

Re: Count ifs help!

Are those all one cell? "yellow frog" is in one single cell ?

Try
=COUNTIFS(A1:A100,"*frog*",A1:A100,"<>*eyes*")

Hello
Thank you very much for your quick answer.
yellow frog is in one single cell
it works but i want you to help me in this case also if you can:
instead of eyes i have the word ey"es (with quotation mark in the middle of the word
i want the same formula you gave me but now do not count ey"es instead of eyes

Thank you again!

 

[Jonmo1]

Re: Count ifs help!

Try
=COUNTIFS(A1:A100,"*frog*",A1:A100,"<>*ey""es*")