Counting Letters

[Gaute Hasti]

How can i count letters in a row?

I want to the letter H to count as 1.
There is also the letter T in the same row, but that letter should count as
0.

 

[Jason Morin]

=COUNTIF(1:1,"H")

HTH
Jason
Atlanta, GA

 

[Bob Phillips]

=COUNTIF(1:1,"H")

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Gaute]

What is the whole formel if the cells to work in is B11-B73 ?

Thanx for answers

 

[Gaute]

What is the whole formel if the cells to work in is B11-B73 ?

Thanx for answers

 

[Bob Phillips]

=COUNTIF("B11:B73","H")

--

HTH

RP
(remove nothere from the email address if mailing direct)