View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Barb Barb is offline
external usenet poster
 
Posts: 70
Default help with function

=SUMIF(Reason,(OR("B Scale",B Scale Night)),M20:M33)

I am trying to sum cells in column M20:M33 if the named cells "Reason"
contain the words "B Scale" or "B Scale Night"

What am I doing wrong?