Here is my formula: {SUMPRODUCT(($C$6:$C$6<><wbr>TRANSPOSE($BD$1:$BD$3))*($G$<wbr>6:$G$6))}
I'm trying to use the range of bd1-3 as a qualifier in my sumproduct.
Textually, I'd like the formula to give me every instance where column C does not equal any of the items listed in BD1:bd3 and to...