Counting cells containing certain words

[dsciola]

Im trying to put together a formula that counts the specific # of times a certain word pops up in a range of cells.

I've been using Countif function and its so far been working when I type in quotes the word I want to count, however, it'd be great if I can link to a cell with the text and drag n drop so I dont have to reenter each word Im trying to count.

Hope that makes sense. Please see attached if interested for example. Thanks!