FUNCTION CATALOGUE / MATH & TRIGONOMETRY
SUMIF Excel function
Adds values that meet one condition.
Correct sentence to use
Add [sum range] where [criteria range] equals [value].
Modify this query in PlainFormula →Example formula
=SUMIF(B:B,"London",D:D)
Adds values from the sum range where the criteria range matches the value.
Syntax
SUMIF(range, criteria, [sum_range])
Argument signature: range, criteria, [sum_range]
Availability note
Commonly available in current Excel; verify platform and locale-specific behaviour.