Sumif with multiple requirements

Drew Cooper

Column A: Team Name

Column B: Total Units

Column C: Type

Column D: Units Won

Column E: Units Lost

What formula would I use to determine multiple things. Example: I only want to count Column D if Column A = Red Team and Column C = Evergreen

Thanks

Paul Newcome

You would use a SUMIFS to incorporate multiple range / criteria sets.

https://help.smartsheet.com/function/sumifs

.