What is wrong with this sumproduct formula?

Marq

Well-known Member
Joined
Dec 13, 2004
Messages
808
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"
 

Marq

Well-known Member
Joined
Dec 13, 2004
Messages
808
i figured it out...I had to remove the quotes from 51014 and 51010
 

Forum statistics

Threads
1,084,906
Messages
5,380,529
Members
401,687
Latest member
elisa pathros

Some videos you may like

This Week's Hot Topics

Top