SUMIFS formula with texts and using OR

[korhan]

I am trying to use an "OR" statement or something similar to capture multiple scenarios in my SUMIFS formula.

=SUMIFS(sumrange,criteria_range_1,"2017"&" "&"*WITHHOLD *",criteria_range_2,criteria_2)

When the year is in the beginning, my formula has no problem and it captures but there some situations where the year is at the end so I am looking for "*WITHHOLD *" & "2017".
How can I incorporate this into my formula so sumifs captures either or.

Below is what I am thinking. How can I translate it into Excel's language?

=SUMIFS(sumrange,criteria_range_1,OR("2017"&" "&"*WITHHOLD *","*WITHHOLD *" & "2017"),,criteria_range_2,criteria_2)

 

[Joe4]

The SUMIFS are structured to treat additional criteria as AND instead of OR.
If you want to do OR-type criteria, one way is to structure it like this:

=SUMIF(first criteria) + SUMIF(second criteria) - SUMIFS(both criteria)