Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum if one or another criteria
I've been trying to figure this out on my own based on other similar posts
but I think I just don't understand array formulas. Anyway... I want to sum a range of cells if 1 of 2 possible criteria are met within a different range of cells. Example: RowA RowB RowC Col1 P S W Col2 4 2 1 Sumif(A1:C1,"P" OR "S", A2:C2) It's the OR that I can't figure out. Thanks a Bunch! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum if one or another criteria
Try
=SUMPRODUCT((A1:C1={P",S"})*(A2:C2)) -- HTH Bob "parls" wrote in message ... I've been trying to figure this out on my own based on other similar posts but I think I just don't understand array formulas. Anyway... I want to sum a range of cells if 1 of 2 possible criteria are met within a different range of cells. Example: RowA RowB RowC Col1 P S W Col2 4 2 1 Sumif(A1:C1,"P" OR "S", A2:C2) It's the OR that I can't figure out. Thanks a Bunch! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum if one or another criteria
Sumproduct((A1:C1={"P","S")*A2:C2)
-- Don Guillett Microsoft MVP Excel SalesAid Software "parls" wrote in message ... I've been trying to figure this out on my own based on other similar posts but I think I just don't understand array formulas. Anyway... I want to sum a range of cells if 1 of 2 possible criteria are met within a different range of cells. Example: RowA RowB RowC Col1 P S W Col2 4 2 1 It's the OR that I can't figure out. Thanks a Bunch! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum if one or another criteria
=SUM(SUMIF(A1:C1,{"P","S"},A2:C2))
"parls" wrote: I've been trying to figure this out on my own based on other similar posts but I think I just don't understand array formulas. Anyway... I want to sum a range of cells if 1 of 2 possible criteria are met within a different range of cells. Example: RowA RowB RowC Col1 P S W Col2 4 2 1 Sumif(A1:C1,"P" OR "S", A2:C2) It's the OR that I can't figure out. Thanks a Bunch! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum if one or another criteria
Awesome! That worked perfectly. For some reason when I tried to use the
sumproduct formula it returned "N/A". "Teethless mama" wrote: =SUM(SUMIF(A1:C1,{"P","S"},A2:C2)) "parls" wrote: I've been trying to figure this out on my own based on other similar posts but I think I just don't understand array formulas. Anyway... I want to sum a range of cells if 1 of 2 possible criteria are met within a different range of cells. Example: RowA RowB RowC Col1 P S W Col2 4 2 1 Sumif(A1:C1,"P" OR "S", A2:C2) It's the OR that I can't figure out. Thanks a Bunch! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Query criteria based on a changing criteria list | Excel Discussion (Misc queries) | |||
Count how many criteria in a column match criteria in another colu | Excel Discussion (Misc queries) | |||
=DMIN(database,field,criteria) question about criteria | Excel Discussion (Misc queries) | |||
Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions |