View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mldancing mldancing is offline
external usenet poster
 
Posts: 28
Default SumProduct Question

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.