=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.
--
Thanks,
Shane Devenshire


"Steven" wrote:


=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

Shane,

That does not return the correct amount.

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

Steven


"ShaneDevenshire" wrote:

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.
--
Thanks,
Shane Devenshire


"Steven" wrote:


=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