Countif or Sumproduct
I know that feeling... :)
In article ,
"Ron Coderre" wrote:
THAT's what I was trying to think of!
It completely eluded me.
***********
Regards,
Ron
XL2002, WinXP-Pro
"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"
|