Can I use sumif with OR to sum based on two column criteria?

D

DLB

I am try to use sumif on two different criteria, but the first criteria could
be "A" or "B".

Somthing like this:
=SUMPRODUCT(--(A3:A6="A" OR "B"),--(B3:B6="C"),C3:C6)

Not even sure if Sumproduct is the right path to follow.

Any thoughts?
 

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

Top