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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Can I use sumif with OR to sum based on two column criteria? (https://www.excelbanter.com/excel-worksheet-functions/209765-can-i-use-sumif-sum-based-two-column-criteria.html)

dlb

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

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?

David Biddulph[_2_]

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

=SUMPRODUCT((A3:A6="A")+(A3:A6="B"),--(B3:B6="C"),C3:C6)
--
David Biddulph

"DLB" wrote in message
...
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?

dlb

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

Thanks David! It works as advertised!

"David Biddulph" wrote:

=SUMPRODUCT((A3:A6="A")+(A3:A6="B"),--(B3:B6="C"),C3:C6)
--
David Biddulph

"DLB" wrote in message
...
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?

All times are GMT +1. The time now is 07:39 AM.