you can add multiple together...

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

Though.. you probab;y dont need the ,--(Data!$H$2:$H$50000).

If you want to add the column H values, should be ,Data!$H$2:$H$50000 instead.

If you just want a count, leave H out entirely. Only necessary if you want
ony to count where H is not blank.

"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))