you can use a range of cells that can span rows and columns (but it needs to be contiguous). Note that you donвЂ™t need to stick to just one column to use this formula. ItвЂ™s almost the same formula where I have added the SUM formula and changed the range is the SPLIT part to include a range instead of a single cell.ДЄnd since I am playing with a range of cells, you need to use ARRAYFORMULA to make sure it gives the right result. = ARRAYFORMULA ( SUM ( COUNTA ( SPLIT ( A2:A4, ' ' ) ) ) ) You can also extend the above formula to give you the word count of all the text in an entire column. Note that this formula works even if you have any leading, trailing, of double spaces in between the words. If you donвЂ™t use the IF function, the formula will return 1 even when the cell is empty. The COUNTA function then simply counts the total number of these delimited values.ДЄnd the reason I have used the IF formula is to make sure I get a blank when there is no text in the cell. In this formula, my delimiter is a space character, so the SPLIT function would give me an array of text string delimited by the space character. The above formula uses the SPLIT function, which separates the text string based on the delimiter. The following formula will give you the word count: = IF ( A2 = '', '', COUNTA ( SPLIT ( A2, ' ' ) ) ) Suppose you have a dataset as shown below and you want to get the word count in each.

Count the Number of Lines in a Text in a Cell.Get the Word Count When Words are of a Specific Length.Get the Word Count of With/Without Specific Words.

Word counter docs