transpose sumproduct

  1. D

    Sumproduct and Transpose Problem (double counting)

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

Some videos you may like

This Week's Hot Topics