View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default SumProduct Question

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.