From: parls on 31 Mar 2010 10:06 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! From: Bob Phillips on 31 Mar 2010 10:10 Try =SUMPRODUCT((A1:C1={P",S"})*(A2:C2)) -- HTH Bob "parls" wrote in message news:FB61B06F-73E4-4E43-9EBB-A9B03F67EACA(a)microsoft.com...> 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! From: Don Guillett on 31 Mar 2010 10:13 Sumproduct((A1:C1={"P","S")*A2:C2) -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett(a)gmail.com "parls" wrote in message news:FB61B06F-73E4-4E43-9EBB-A9B03F67EACA(a)microsoft.com...> 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! From: Don Guillett on 31 Mar 2010 10:16 Oops ) should have been } -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett(a)gmail.com "Don Guillett" wrote in message news:euEfMxN0KHA.6108(a)TK2MSFTNGP06.phx.gbl...> Sumproduct((A1:C1={"P","S")*A2:C2) > > > -- > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguillett(a)gmail.com > "parls" wrote in message > news:FB61B06F-73E4-4E43-9EBB-A9B03F67EACA(a)microsoft.com... >> 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! > From: Teethless mama on 31 Mar 2010 13:23 =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!  |  Next  |  Last Pages: 1 2 Prev: Re Try ThisNext: Return Value from a Range (depends on input to determind month