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.
|