|Since I can't see your spreadsheet from where I'm sitting, I'll guess that either the cells don't contain the word hot or that your formula isn't looking for the word hot.|
Find a cell in the range that you are trying to count that looks like it contains hot. Let's say it's A5.
In another cell, say B1, enter this:
If it doesn't return TRUE, then A5 doesn't contain hot.
Maybe there's an extra space or a non-printing character or something like that going on.
Try the CLEAN and/or TRIM function on the cells to see if that helps.