sum if one or another criteria

[parls]

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!

 

[Bob Phillips]

Try

=SUMPRODUCT((A1:C1={P",S"})*(A2:C2))

 

[Don Guillett]

Sumproduct((A1:C1={"P","S")*A2:C2)

 

[Don Guillett]

Oops
) should have been }

 

[Teethless mama]

=SUM(SUMIF(A1:C1,{"P","S"},A2:C2))

 

[parls]

Awesome! That worked perfectly. For some reason when I tried to use the
sumproduct formula it returned "N/A".