Yeah, you're right.

Make that:

=SUMPRODUCT(--(C91:C103<""),--(ISERROR(SEARCH(A91:A93,C91:C103))),--(ISNUMBER(SEARCH(A94,C91:C103))))

Biff

"Max" wrote in message
...
Biff,

Assuming sample data within C91:C103 is:

Barbie Doll - cancel
Beanie Babies - cancel
Boats - cancel
Stuffed Toys - cancel
Teddy Bears
Toy Cars
Lego
<rest of range blank

your formula returns: 1, while mine returns: 2

From my understanding of the OP's specs,
the count based on the sample data above should be 2,
viz.: Teddy Bears & Lego

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"T. Valko" wrote:
OK, now I see why you had this in your other formula:

*ISERROR(SEARCH("cancel",C$91:C$103))

Try this:

A91:A94 = Barbie Doll, Beanie Babies, Toy Cars, cancel

=SUMPRODUCT(--(C91:C103<""),--(ISERROR(SEARCH(A91:A93,C91:C103))))-COUNTIF(C91:C103,"*"&A94&"*")

Biff