FUNCTION CATALOGUE / MATH & TRIGONOMETRY
SUMIFS Excel function
Adds values that meet multiple conditions.
Correct sentence to use
Add [sum range] where [condition 1] and [condition 2].
Modify this query in PlainFormula →Example formula
=SUMIFS(D:D,B:B,"London",C:C,">100")
Adds values that satisfy every supplied condition.
Syntax
SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)
Argument signature: sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], …
Availability note
Commonly available in current Excel; verify platform and locale-specific behaviour.