how to count words in excell?

formula provided by F1 Excel help doesn't work, the cell showing the text of
the formula

I made sure there are no circular references (formula cell and the range it
was to calculate are mutually exclusive).