A bit longish, but think this returns what you're after:
=COUNTIF(C$91:C$103,"<")-SUMPRODUCT((ISNUMBER(SEARCH("Barbie
Doll",C$91:C$103))*ISERROR(SEARCH("cancel",C$91:C$ 103)))+(ISNUMBER(SEARCH("Beanie
Babies",C$91:C$103))*ISERROR(SEARCH("cancel",C$91: C$103)))+(ISNUMBER(SEARCH("Toy Cars",C$91:C$103))*ISERROR(SEARCH("cancel",C$91:C$ 103))))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"mldancing" wrote:
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.