S
Steven
I have this and it works fine:
=SUMPRODUCT(($A$14:$A$30002=$B$1)*($B$14:B$30002=$A$3)*($C$14:$C$30002=$C$2)*($D$14:$D$30002))
And this works fine if I want more than one value from column A:
=SUMPRODUCT(SUMIF(A14:A30002,{"A","B","C"},D1430002))
But how do I include the the column B and C columns and criteria into the
2nd formula.
Thank you,
Steven
=SUMPRODUCT(($A$14:$A$30002=$B$1)*($B$14:B$30002=$A$3)*($C$14:$C$30002=$C$2)*($D$14:$D$30002))
And this works fine if I want more than one value from column A:
=SUMPRODUCT(SUMIF(A14:A30002,{"A","B","C"},D1430002))
But how do I include the the column B and C columns and criteria into the
2nd formula.
Thank you,
Steven