Counting Letters
 

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.

=COUNTIF(1:1,"H")

HTH
Jason
Atlanta, GA

-----Original Message-----
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.


.

=COUNTIF(1:1,"H")

--

HTH

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


"Gaute Hasti" wrote in message
...
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.

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

Thanx for answers ;)


"Jason Morin" wrote in message
...
=COUNTIF(1:1,"H")

HTH
Jason
Atlanta, GA

-----Original Message-----
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.


.

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

Thanx for answers ;)

"Gaute Hasti" wrote in message
...
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.

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

--

HTH

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


"Gaute" wrote in message
...
What is the whole formel if the cells to work in is B11-B73 ?

Thanx for answers ;)


"Jason Morin" wrote in message
...
=COUNTIF(1:1,"H")

HTH
Jason
Atlanta, GA

-----Original Message-----
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.


.