count how many times I've got the same character in text from several cells

[charlie92_uk]

Hi smart people!

this should be not too difficult for you...

I need to count how many times I've got, for instance, "a" in several cells where I typed some text...
I would need a formula where I can indicate the letter I want and the range of cells where to look at, and having as result how many occurances there are...
If you are very good instead of a single letter, maybe a sequence of letters... but this is an extra!

thanks for your help!

 

[davesweep]

Hi,

Does this work?

=COUNTIF(C1:C10,"a")

 

[charlie92_uk]

Hi Dave,

In fact this was my first try, but it didn't work...
If in a cell I type "assessment", I would like a formula that counts in the text what I want, for ex "s", and in this case it returns 4...
COUNTIF counts how many cells satisfy my request, it doesn't work inside the cell itself... at least I can't, maybe somebody else can...

thanks

 

[Sanjeev1976]

Try

=LEN(A1)-LEN(SUBSTITUTE(A1,"s","")) where A1 contains the word.

 

[charlie92_uk]

Seriously man, this is cool, really cool...

congrats mate, you are much cleverer then me...

 

[Sanjeev1976]

Thanks for the feedback. Hope it met your requirement