Excel Formulas to Count Total Words in a Range ~ Useful Tips!!

So far we have learned the formulas to count the total characters in a cell, total characters in a range, total words in a cell. Similarly, here we will discuss the formulas to count the total number of words in a range of cells in Excel. Let’s jump into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Generic Formula:

You can use the below formula to find out the total number of characters in a range.

=SUMPRODUCT(LEN(TRIM(A1))-LEN(SUBSTITUTE(A1,” “,””))+1)

Syntax Explanations:

SUMPRODUCT – It helps to multiply the corresponding arrays or ranges and returns the sum of the products. Read more on the SUMPRODUCT function.
LEN – In Excel, the LEN function is used to find the length of the text string.
TRIM – This function helps to remove the extra spaces from the text and there is no space at the start or end of the text string. Read more on the TRIM function.
SUBSTITUTE – This function helps to replace existing text with new text in a text string when you want to replace text based on its content, not position. Read more on the SUBSTITUTE function.
Range – It represents the input value.
Comma symbol (,) – It is a separator that helps to separate a list of values.
Parenthesis () – The main purpose of this symbol is to group the elements.
Minus Operator (-) – This symbol will help to subtract any two values.
Plus operator (+) – This symbol is used to add the values.

Practical Example:

Refer to the below example image.

Here, we will enter the input text strings in Column B.
Now we need to find out the total number of characters in a range of cells.
You can refer to the following article to count the total words in a cell.

Select any cell and type the above-given formula.

Finally, press the ** ENTER** key, you can get the result as shown below.

Conclusion:

Here we have described the simple tricks to count the total number of words in a range of cells in Excel. Hope you like it. Mention your queries in the comment box below.

Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **