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 *!! **
    Related Articles:

    29

    This website collects cookies to deliver better user experience

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