Example:

Barbie Doll
Beanie Babies
Boats - Cancel
Stuffed Toys - Cancel
Teddy Bears

So the answer should just be 1 (count for 1 occurance of Teddy Bear only).
Since I don't want to count Barbie Doll, Beanie Babies, and anything that has
the word "Cancel".




"T. Valko" wrote:

Let me see if I got this straight.....

You want to count the number of cells in a range that *do not* contain any
of the following:

Barbie Doll
Beanie Babies
Toy Cars
cancel

Make a list of those strings in a range of cells:

A91 = Barbie Doll
A92 = Beanie Babies
A93 = Toy Cars
A94 = cancel

Then:

=SUMPRODUCT(--(ISERROR(SEARCH(A91:A94,C91:C103))))

Biff

I'm assuming that since you're using SEARCH in your formula these are
substings.
"mldancing" wrote in message
...
There shouldn't be any. But if there is something that says "cancel", then
the formula shouldn't count it.

Thank you.


"T. Valko" wrote:

Are there any empty/blank cells in the range?

Biff

"mldancing" wrote in message
...
I have this formula that count the number of times "Barbie Doll" occurs:

=SUMPRODUCT((ISNUMBER(SEARCH("Barbie
Doll",C$91:C$103))*ISERROR(SEARCH("cancel",C$91:C$ 103))))

How can I change the formula to count everything else OTHER THAN these
items: Barbie Doll, Beanie Babies, Toy Cars?

Please help. Thank you.