To get the word count of the whole sheet, you have to apply the same formula to every cell and add all the counts to get a final number. This is how we get the word count in an Excel sheet.

Click on the cell that you want to have display the phrase count. Note that you cannot use a cell that is within the cells you'll be searching. If you do, Excel will give you a circular reference ...

Because there is a space character between each word, you can count the words simply by counting the number of spaces between those words, and then add 1 to account for the last word. For example, ...