If there will be a maximum of one specifc word per cell:
=COUNTIF(range, "specifc")
If the specifc word can occur multiple times within a cell, array-enter
(CTRL-SHIFT-ENTER or CMD-RETURN):
=SUM(LEN(range)-LEN(SUBSTITUTE(range, "specifc","")))/LEN("specifc")
