View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Go Bucks!!![_2_] Go Bucks!!![_2_] is offline
external usenet poster
 
Posts: 28
Default SUMIFS with an OR criteria

I currently have the formula:
=SUMIFS('Labor Reclasses'!$D$6:$D$8000,'Labor
Reclasses'!$M$6:$M$8000,Summary!$A4,'Labor
Reclasses'!$F$6:$F$8000,"Travel-Non-Dispatch",'Labor
Reclasses'!$F$6:$F$8000,"Travel"))

I want to change the last two criteria to an OR. Thus the value in column D
would be added for all cases where Column M matches Summary!A4, and Column F
is either "Travel-Non-Dispatch" or "Travel"

Thanks,