32
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
- Use the below formula to count a specific range of cells in Excel.
=SUMPRODUCT(LEN(range)-LEN(SUBSTITUTE(range,text,””)))
- 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.
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.
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 *!! **
32