View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
parls parls is offline
external usenet poster
 
Posts: 5
Default sum if one or another criteria

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!