What is wrong with this formula? I should be getting a result of 104 but i get no value returned. No error in the cell either. The cell is blank.
=SUMPRODUCT(($I$3:$I$2000="")*($E$3:$E$2000="51014")*($K$3:$K$2000)+($I$3:$I$2000="")*($E$3:$E$2000="51010")*($K$3:$K$2000))
I'm asking it to read column "I" and if a cell is blank in column "I"..then read column "E" and if there is a 51014 OR a 51010 in its adjoining cell then give me the value in column "K"
=SUMPRODUCT(($I$3:$I$2000="")*($E$3:$E$2000="51014")*($K$3:$K$2000)+($I$3:$I$2000="")*($E$3:$E$2000="51010")*($K$3:$K$2000))
I'm asking it to read column "I" and if a cell is blank in column "I"..then read column "E" and if there is a 51014 OR a 51010 in its adjoining cell then give me the value in column "K"
