=SUMPRODUCT((Data!$F$2:$F$50000={4282,3826,7892})* (Data!$I$2:$I$50000=A9)*(Data!$H$2:$H$50000))

--
__________________________________
HTH

Bob

"pgarcia" wrote in message
...
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))