word count within specific cells

Assuming the word can only happen once per cell, countif will do the job:

Please Login or Register  to view this content.

If the word can happen more than once per cell, here's a formula that will get the proper count:

Please Login or Register  to view this content.

Note that Sumproduct is much less efficient than Countif, so it's best to limit the range instead of using the whole column.