SUMPRODUCT

  • Thread starter Thread starter Steven
  • Start date Start date
S

Steven

=SUMPRODUCT(($A$14:$A$30002={"A","B","C"})*($B$14:B$30002={"01","02"})*($C$14:$C$30002=$C$2)*$D$14:$D$30002)


Why does this not work. It should actually return a valid total.

Thank you,

Steven
 
Hi,

You are multiplying two arrays together with different numbers of elements.
A quick workaround would be to add a third element to {"01","02","XX"}

The third element would be a dummy element.

If this helps please click the Yes button.
 
Shane,

That does not return the correct amount.

It returns the "A" ; "01" ; $C$2 value.

Steven
 
Back
Top