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

  • Thread starter Thread starter DLB
  • Start date Start date
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

Similar Threads

sumproduct with multiple variables 8
Sum If Formula with 3 criteria 4
Sumif with Multiple Criteria 3
SUMIF with criteria "<>" & "=" 4
SUMIFS, one criteria range, multiple criteria 3
sumif or sum production - 3 or more criteria 5
Sum on multiple columns with search criteria 6
SUMIFs across multiple sheets 7

Back
Top