Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
=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
|
|||
|
|||
=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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
=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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
no row numbers or column letters DISPLAYED | Excel Discussion (Misc queries) | |||
Counting... | Excel Worksheet Functions | |||
Looking for an easy way to replace letters with acutes | Excel Worksheet Functions | |||
Excel column headings from numbers to letters | Excel Discussion (Misc queries) | |||
How do I change column labels from numbers to letters in Excel? | Excel Discussion (Misc queries) |