sum if one or another criteria

  • Thread starter Thread starter parls
  • Start date Start date
P

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!
 
Awesome! That worked perfectly. For some reason when I tried to use the
sumproduct formula it returned "N/A".
 
Back
Top