One way:
=SUMPRODUCT((ISNUMBER(SEARCH("100/101",A1:A10))*ISERROR(SEARCH("cancel",A1:A10))))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"mldancing" wrote:
I need to count if there's the number of ocurrences containing 100/101 but
when it does not have the word "cancel".
May be something like that:
COUNTIF(A1:A10,"*100/101*") but <"cancel"
Please help.