Counting specific characters within a range

[PaperBoyz]

Hi all ... Searched for a while but didn't find quite what I was looking for.

Is there a formula that returns a count of the occurrences of a specific text within a range of cells? Specifically, I am looking to count the occurrences of commas (".") and, separately, the occurences of the single capital letter "X" within the range of cells D3:BC3. There might be more than one comma in any particular cell.

 

[Aladin Akyurek]

=SUMPRODUCT(LEN(D3:BC3)-LEN(SUBSTITUTE(D3:BC3,",","")))

 

[PaperBoyz]

Worked perfectly, and so simple and elegant I wish I'd thought of it myself (should have). Thanks!

 

[gary_parker]

Apologies, however, I believe the premise of the questions are near identical.

But, I'll start a new topic.

Cheers