Assuming the word can only happen once per cell, countif will do the job:
=COUNTIF(V:V,"*awesome*")