Basically:

Why does this not work:

=SUMPRODUCT((SUMIF($A$14:$A$30002,{"A","B"}))*($B$ 14:B$30002=$A$3)*($C$14:$C$30002=$C$2)*($D$14:$D$3 0002))

where column D are the amounts.

Thank you,


Steven

"Steven" wrote:

What I am looking for is that the 1st function has sumproduct on three
different columns but the criteria is only one item. The 2nd function has
one column but multiple criteria How do I make the formula so I can sum on
multiple criteria in column A ; and then also include in the function columns
B and C and their criteria.

Thank you,

Steven

"Don Guillett" wrote:

I may not be understanding what you want but try
=SUMPRODUCT(A14:A30002={"A","B","C"}),D14:D30002)


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Steven" wrote in message
...
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"},D14:D30 002))

But how do I include the the column B and C columns and criteria into the
2nd formula.

Thank you,

Steven