Try something like the following...

=SUMPRODUCT(--(ISNUMBER(FIND("FL",A1:A10))),--(B1:B10="Y"))

Note that FIND is case sensitive. If you don't want the case to be
sensitive, use SEARCH instead.

Hope this helps!

In article ,
Harley wrote:

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