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: