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!

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!

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!

Oops
) should have been }
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Don Guillett" wrote in message
...
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!

=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!

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!