Adding A range of cells that have a certain text letter

D

Dave

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

Bob Phillips

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

--
HTH

Bob Phillips

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate end date and time 1
Urgent help with Excel formula. Please please help 1
Dynamic pointing to a cell 0
Compare last digit in 5 cells for match 0
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Conditional Formatting - Given dates within certain range of days 4
Count the remaining weekdays in a data range excluding holidays and start/end dates 5
Varying cell ranges in formulas according to number of cells with certain value 1

Top