#1   Report Post  
Gaute Hasti
 
Posts: n/a
Default 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.


  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

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


.

  #3   Report Post  
Bob Phillips
 
Posts: n/a
Default

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




  #4   Report Post  
Gaute
 
Posts: n/a
Default

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.


.



  #5   Report Post  
Gaute
 
Posts: n/a
Default

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.






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


.





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
no row numbers or column letters DISPLAYED RagDyer Excel Discussion (Misc queries) 4 April 24th 23 03:42 AM
Counting... Patrick G Excel Worksheet Functions 3 February 23rd 05 10:05 PM
Looking for an easy way to replace letters with acutes Speak-ezy Excel Worksheet Functions 4 January 26th 05 05:04 PM
Excel column headings from numbers to letters happygolucky Excel Discussion (Misc queries) 2 January 21st 05 06:15 PM
How do I change column labels from numbers to letters in Excel? AllisonCincy Excel Discussion (Misc queries) 2 December 9th 04 12:55 AM


All times are GMT +1. The time now is 11:44 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"