If the word can happen more than once per cell, here's a formula that will get the proper count:
=SUMPRODUCT((LEN(V1:V10)-LEN(SUBSTITUTE(V1:V10,"awesome","")))/LEN("awesome"))
Note that Sumproduct is much less efficient than Countif, so it's best to limit the range instead of using the whole column.