Formula to count the occurrences of specific letter in excel

[Mithun Seth]

Hello Friends,

Do you know any excel formula by using that we can count the occurrences of specific letter in excel? For example if there is one cell of excel which contains "DFGHG" text within it. If we want to find out the count of "G" then function should give result "2". I don't have any idea regarding this type of any excel formula. If you knows any formula for this then please let me know that.

[Eric B]

You can try following formula:

=len(B1)-len(substitute(B1,"Specify letter",""))

In above formula you just need to provide the name of the cell and the character for which you you want to count the occurrence. See below example, in which formula counts the occurrences of letter "J"

=len(D1)-len(substitute(D1,"J",""))

[Glenny]

Hi,

To count the occurrences of specific letter in excel I have used "COUNTIF" function of Microsoft excel. In which you will need to type the range of the excel cell and the desired character. Following are it's syntax and example:

Syantax:
= COUNTIF (Range of cells,"letter")

Example:
= COUNTIF (C1:C22,"P")

[JonathanD]

There are two methods are available int the Microsoft excel to count the occurrences of specific letter. Following are those;

First method:
You need to Use "COUNTIF()" function, and give the rrange of cells and text as a input for this function. see below
= COUNTIF (Range,"Specific text") .

Second method:
You need to Use "SUM()" function, and give the range of cells and text as a input. see below
= SUM (IF (Range="Specific text",2,0))

[Macarenas]

Hi friend,

There are some function are available in the excel which are used to count of particular letter. These functions includes 'SUM' and 'COUNTIF'. You can use CTRL+SHIFT+ENTER for entering these formulas . You just need tom mention the cell range and the letter in these functions. If you want to know more about these function then go through the below link:
http://support.microsoft.com/kb/214153

[ThoMas321]

Hello friends,

Use something below formula for your query:

1. CountIf (cell RANGE,"txt")
2. LEN (F1) - LEN (SUBSTITUTE(F1,D1,""))
3. SUM (if (cell RANGE="txt",3,1))