I would introduce 2 helper columns. Of course it can be done many other
ways, but this way it is easy to check that your formula does what it is
supposed to do.
If your "Y"s are in A and your text in B, Then this in C:

=IF(AND(A1="y",NOT(ISERROR(C1))),1,0)

and this in D:

=IF(AND(A1="y",NOT(ISERROR(C1))),1,0)

both copied down as far as needed

Sum column D
--
Kind regards,

Niek Otten



"Harley" wrote in message
...
I need to count all cells in one column containing "FL" anywhere in the
sentence if the condition in another column is "Y"