**SUMIFS adds value in an array provided all arguments are met.**

SUMIFS has 3 arguments:

**sum_range:**

A table range of values which will be added together.

**criteria_range:**

A table __range__* *where values "targets" reside.

**criteria:**

Is a value that must be met for addition to happen.

In the example above, a function works by taking column number from *sum_range* input (column C) and assigning row number by matching value of IL (J4) to value specified in *criteria_range* (column B). The matches for value in J4 in column B are rows 4,5,7,9. These row values are combined with a column value from *sum_range,* which is column C. The final value of cells to be added together are, C4,C5,C7,C9.

References are locked by pressing F4 or entering $ sign beside the column or range indicators. This is done to quickly copy the formula as it is dragged. During dragging down, a formula will not change.

A simpler version of the same function is a SUM function.

**SUM functions adds together specified values.**

The function has only one argument:

**number1:**

Lists values or __range__ of values which will be added together.

In the example above, we added two regions together. This could be achieved two different ways:

Directly type in values: =SUM(530,535)

Directly reference cells =SUM(K4,K5)

List a range =SUM(K4:K5)

All three examples would give the same result.