SUMPRODUCT
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
|