| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SumIf formula from one column based on criteria from two other col | Excel Discussion (Misc queries) | |||
| sumif-add amount to another cell based on two criteria | Excel Discussion (Misc queries) | |||
| SumIf based on two criteria | Excel Worksheet Functions | |||
| SUMIF in multiple columns based on other criteria in Excel? | Excel Discussion (Misc queries) | |||
| Is it possible to use the sumif function based on the criteria of. | Excel Worksheet Functions | |||
Linear Mode
