Try...
=SUMPRODUCT(--(ISNUMBER(SEARCH("box",A1:A10))),--(1-ISNUMBER(SEARCH("not"
,A1:A10))))
Hope this helps!
In article ,
amntre wrote:
I have a column of text cells (each with different number of words),
And need to count those cells which meets the following conditions:
They have the text €śbox€ť and dont have the text €śnot€ť in them.
For example: €śWhite boxes not present €ś- should not be counted
€śBoxes cover€ť - should be counted.
Thanks
|