Countif or Sumproduct
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"
|