Ok, after a good nights sleep........

This is my final answer <g

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

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

Biff

"Max" wrote in message
...
Testing with a slightly revised sample data within C91:C103 of:

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

reveals your amended formula returns: 1, while mine returns: 3

The count based on the sample data above should be 3,
viz.: Stuffed Toys, Teddy Bears & Lego
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"T. Valko" wrote:
Yeah, you're right.

Make that:

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

Biff