Countif counting letters

[Tresfjording]

Hi ...
Came across a peculiar event today.
Sitting here on a Saturday night doing absolutely worthless and useless work in Excel, one has to be a nerd.

I need to count the number of certain letters in a row. So I have this formula, see attached spreadsheet, to do so.
The formula

Please Login or Register  to view this content.

will set a "h" in the cells B5 and C5, ready to be counted.
The formula

Please Login or Register  to view this content.

in the row below counts them.
The formula

Please Login or Register  to view this content.

in the adjacent cell puts a "hh"' in cell D4.
The formula

Please Login or Register  to view this content.

in E5 counts only cells with one "h" in each. The answer should be three.

How can I count how many "h"'s there are i a row, even in cells containing a string with a varying number of "h"'s in it?

[TMS]

Seems to be a problem opening the attachment. Tried twice and it tells me the file is corrupt. Maybe try again.

[Tresfjording]

Okay ... Sorry about that.
It works fine here on my computer.
But re-uploaded it once again just now.

[CARACALLA]

F5=LEN(B5&C5)-LEN(SUBSTITUTE(B5&C5,"h",""))

[Tresfjording]

Hi CaraCalla:
Did yo test this in the spreadsheet?
It won't work here.
And I have of course translated it correctly.

[CARACALLA]

Also , with ;

[Tresfjording]

Yupp ... of course

[Rick Rothstein]

Hi CaraCalla:
Did yo test this in the spreadsheet?
It won't work here.

CARACALLA's formula works fine for me inside of the file you posted. When you say "it won't work here", what exactly happens when you try it?

[Tresfjording]

Sorry .. My bad ....
I used the Norwegian ERSTATT instead of BYTT when replacing SUBSTITUTE.
It works fine now!
Thank you!