That got it!!

Thanks!

"Domenic" wrote:

Try...

=SUMPRODUCT((ISNUMBER(FIND({"FLH","FLT"},A1:A10))) *(B1:B10="Y"))

Hope this helps!

In article ,
Harley wrote:

This did work - Thanks. I do have one situation where I need the formula to
find "FLH" or "FLT" under the same scenrio. Any thoughts?
Thanks again,

Harley

"Domenic" wrote:

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"