Try this ... needs only regular entry:

=SUMPRODUCT(($A$14:$A$30002=T(INDIRECT({"B1","B2", "B3"})))
*($B$14:B$30002=$A$3)*($C$14:$C$30002=$C$2)*$D$14: $D$30002)

Assumes values in B1, B2, and B3 are Text.
If they're numeric, change the "T" in front of Indirect to an "N".

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"Steven" wrote in message
...
One last question:

Instead of {"A","B","C"} is there a way to use cell references? I have
tried many things without sucess.

Thank you,

Steven


"Steven" wrote:

Yes, Thank you very much.

"Ragdyer" wrote:

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit
!
---------------------------------------------------------------------------
"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