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