How can I count the cells that contain a specific word?

[excelos]

Hello!

How can I count all the cells in a specific range that contain in their text a specific word? If it is easier, we can choose the cells that 'start' with a specific word (that would also be applicable).

Can I use COUNTIF with wildcards?

Thanks!

 

[Fluff]

Can I use COUNTIF with wildcards?

Yes

 

[My Aswer Is This]

Try it like this:
=COUNTIF(F1:F12,"*Cake*")

 

[excelos]

Thanks!

Could you tell me please where the typo is in this:

=IF($B$47>0,IF(AND(C24>=0,C24<$C$6),"UNDERCAPACITY WITH BOTTLENECK "+"C$24-$C$6","OVERCAPACITY "+"$B$47/COUNTIF($C$47:$DR$47,"OVERCAPACITY*")"),IF(AND(C24>=0,C24<$C$6),"UNDERCAPACITY WITHOUT BOTTLENECK "+"C$24-$C$6",0))

it highlights the region of COUNTIF($C$47:$DR$47,"OVERCAPACITY*")"),

 

[jtakw]

Hi,

Without seeing your data and a description of what you're trying to accomplish, this is just an attempt to "fix" your existing formula, can probably be shortened a bit if we know what exactly you're trying to do:

=IF($B$47>0,IF(AND(C24>=0,C24<$C$6),"UNDERCAPACITY WITH BOTTLENECK "&C$24-$C$6,"OVERCAPACITY "&$B$47/COUNTIF($C$47:$DR$47,"OVERCAPACITY*")),IF(AND(C24>=0,C24<$C$6),"UNDERCAPACITY WITHOUT BOTTLENECK "&C$24-$C$6,0))