SUMPRODUCT

[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

 

[ShaneDevenshire]

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.

 

[Steven]

Shane,

That does not return the correct amount.

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

Steven