SUMIFS

Sums values meeting multiple criteria. First argument is the sum range; subsequent pairs are criteria range + criteria.

Syntax

smartsheet-mastery
=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2, ...])

Example

smartsheet-mastery
=SUMIFS([Budget]:[Budget], [Dept]:[Dept], "Engineering", [Status]:[Status], "Approved")
=SUMIFS({Budget Range}, {Department Range}, "Marketing")