countif help

[Jacob]

I have a coulm like this

***vacant***
***fire-vacant***
name
***vacant***
I want to have a function that would tell me how many rows (cells)
"contains" the word "vacant"?

 

[Dave Peterson]

=countif(a1:a10,"*vacant*")

Will count the cells that contain vacant.

 

[JE McGimpsey]

One way:

=COUNTIF(A:A,"*vacant*")