You can do that by adding your criteria ranges together, and then multiplying.

=SUMPRODUCT(((Data!$F$2:$F$50000="4282")+(Data!$F$ 2:$F$50000="3826")+(Data!$F$2:$F$50000="7892"))*(D ata!$I$2:$I$50000=A9)*(Data!$H$2:$H$50000))
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"pgarcia" wrote:

Can you add more then one item in the following formula?

=SUMPRODUCT(--(Data!$F$2:$F$50000="Citibank"),--(Data!$I$2:$I$50000=A9),--(Data!$H$2:$H$50000))

=SUMPRODUCT(--(Data!$F$2:$F$50000="4282" or "3826" or
"7892"),--(Data!$I$2:$I$50000=A9),--(Data!$H$2:$H$50000))