Excel Formulas to Count specific characters in a range ~ Easy Tricks!!

In the previous post, we have learned the formulas to count the specific characters in a cell. Likewise, here we will explain the simple formulas to count the specific characters in a range of cells and sum all the values 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

General Formula:

Use the below formula to count a specific range of cells in Excel.

=SUMPRODUCT(LEN(range)-LEN(SUBSTITUTE(range,text,””)))

Syntax Explanations:

LEN – In Excel, the LEN function is used to find the length of the text string.

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.

SUMPRODUCT – It helps to multiply the corresponding arrays or ranges and returns the sum of the products. Read more on the SUMPRODUCT 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.

Practical Example:

Let’s consider the below example image.

Here we will enter the input values in Column B.

Now we need to count specific characters in a range of cells and sum the values.

You can refer to the following article to count the specific characters.

Then, select any cell and type the above-given formula.

Finally, press the ENTER key to get the result out, if you need, drag the fill handle over range to apply the formula.

Wind-Up:

From this chapter, you can get to know the simple formulas to count specific characters in a range of cells and sum the values in Excel. Leave a comment or reply below to let me know what you think!

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

Excel Formulas to Convert the String into Array ~ Quick Tricks!!

Excel Formulas to Count the Specific Keywords in the Cell ~ Easily!!

How to Protect All Cells with Formulas using Macros in Excel 365?

How to Find the Last Column of Data in Excel Office 365?