SUMIF(list, condition)

Conditionally sums values in the list. For example:

SUMIF(A1..A10, "<100")

adds up all the values less than 100 in the range A1..A10. Note that the condition must be surrounded by quotes if it contains non-numeric characters.

More examples:

Formula

Returns

SUMIF({5, 4, 5, 3, 5}, ">=4")

19

SUMIF({5, 4, 5, 3, 5}, 5)

15

See also:

COUNTIF(list, condition)

Other mathematical functions