=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