Sumifs multiple criteria from drop down list

Hi guys
Have a workbook named DATA that I've created a drop down list I'm referencing for several sumifs formulas. Basically, there's 3 different actions I want the drop down list to calculate:

1. Sumifs ALL (basically, if All, sum everything from column, don't exclude anything)
2. Sumifs *flash* ONLY (only include fields WITH *flash* in column)
3. Sumifs ALL EXCEPT *flash* (include all in column unless field contains *flash)

Looking for ONE formula referencing the drop down to return results of one of the 3 scenarios above. Anecdotally, if you were to ADD scenarios #2 and #3, it would equal scenario #1.

Really appreciate your expert advice here.

Thanks
Adam

Hi!

You can try this:

1. =SUM(Range)
2. =SUMIF(Range_criteria, "*flash*", Sum_Range)
3. =SUMIF(Range_criteria, "<>*flash*", Sum_Range)

Blessings!