View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default 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!!!