Adding A range of cells that have a certain text letter
 

How do I create the formula that will add a range of cells with a certain
text letter?
Ex. A1 =NCW
A2 =NCFY
A3= NCWF
A4=NCFP

I want A5 to contain the number of "F's" in the range of cells A1:A4. In
this case the answer would be 3.
--
Dave
Lifes a Kick!!!

Adding A range of cells that have a certain text letter
 

=COUNTIF(A1:A4,"*F*")



"Dave" wrote:

How do I create the formula that will add a range of cells with a certain
text letter?
Ex. A1 =NCW
A2 =NCFY
A3= NCWF
A4=NCFP

I want A5 to contain the number of "F's" in the range of cells A1:A4. In
this case the answer would be 3.
--
Dave
Lifes a Kick!!!

Adding A range of cells that have a certain text letter
 

=SUMPRODUCT(LEN(A1:A4)-LEN(SUBSTITUTE(A1:A4,"F","")))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Dave" wrote in message
...
How do I create the formula that will add a range of cells with a certain
text letter?
Ex. A1 =NCW
A2 =NCFY
A3= NCWF
A4=NCFP

I want A5 to contain the number of "F's" in the range of cells A1:A4. In
this case the answer would be 3.
--
Dave
Lifes a Kick!!!

Adding A range of cells that have a certain text letter
 

try this:
=SUMPRODUCT(--(ISNUMBER(SEARCH("F",A1:A4))))

---------------
mama no teeth


"Dave" wrote:

How do I create the formula that will add a range of cells with a certain
text letter?
Ex. A1 =NCW
A2 =NCFY
A3= NCWF
A4=NCFP

I want A5 to contain the number of "F's" in the range of cells A1:A4. In
this case the answer would be 3.
--
Dave
Lifes a Kick!!!