Excel Formulas to Count Total Characters in a Range ~ Quick Tricks!!

Have you ever tried to find out the total number of characters in a range? Do you have any good methods for solving this task in Excel? In this article, I introduce some formulas which can quickly count the total number of characters in a range in Excel. Let’s see them below!! 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(Range))

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.
Range – It represents the input value.
Parenthesis () – The main purpose of this symbol is to group the elements.

Practical Example:

Let’s consider the below example image.

First, 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 total characters 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.

Bottom-Line:

So yeah guys this is how you can use the formulas to count the total number of characters in a range of cells in Excel. Hope you like it. Please share your query below in the comment box. We will assist you.

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