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