View Single Post
  #6   Report Post  
Bob Phillips
 
Posts: n/a
Default

=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.


.