Use cells to hold the criteria:

A1 = 4282
A2 = 3826
A3 = 7892

=SUMPRODUCT(--(ISNUMBER(MATCH(Data!F2:F50000,A1:A3,0))),--(Data!I2:I50000=A9),Data!H2:H50000)

--
Biff
Microsoft Excel MVP


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