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!