Frequency of A Letter In A Range of Cells

[Ark68]

Hi folks, hopring someone can give me a hand ...

With vba, how can I count the frequency that the letter "e" exists with the cells of a range?

Considering my range is B2:B6, I need the count of all the letter 'E' in those cells.

 

[RoryA]

You could use:

evaluate("SUM(LEN(B2:B6)-LEN(SUBSTITUTE(B2:B6,""e"","""")))")

Note that that is case sensitive.

 

[jmacleary]

Hi there. You don't need VBA as you can do it with a formula like this:

=SUMPRODUCT(LEN(B2:B6)-LEN(SUBSTITUTE(B2:B6,"E","")))

If you actually want to do it in vba, then post back.