SUMPRODUCT with OR?

P

pgarcia

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

can I use IF with SUMPRODUCT????? 2
Transfer data between two tables 3
Using If with SumProduct help please! 2
SUMPRODUCT calcs correctly on one PC, but incorrectly on another 2
Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
Formula Problem 3
complex count formulas using multiple criteria in different ranges 4
median array help 2

Top