# SUMIFS

Sum a range based on criteria.

### Parameter List

Syntax
SUMIFS(sum_rangecriteria_range1criterion1
[criteria_range2criterion2]
)
sum_range

The range of values to add to the sum. For example: `A1:A5`.

criteria_range1

The range of conditional values to check against `criterion1`. Must be of the same size as `sum_range`. For example: `B1:B5`.

criterion1

The condition to apply to `criteria_range1`. For example: `">20"`.

[optional] criteria_range2

An additional range of conditional values to check against `criterion2`.

More details

In `sum_range`, you can only sum numbers greater than `0` or Booleans (`True` equates to `1`, `False` equates to `0`).

You can use:

• `""` to sum all the elements where `criteria_range` has no value.

• `"<>"` to sum all elements where `criteria_range` is not empty.

• `"<>number"` or `"<>text"` to sum all the elements that are not equal to that number or text in `criteria_range`.

• Operators such as `">"` or `">="` to sum all the elements where this equates to true.

### Examples

SUMIFS(A1:A5, B1:B5, ">20") returns 5