Sum Functions

The name of the function itself defines the usability of the function.

We use the function for calculating the sum.

There are four functions in excel.

1. SUM: Sums all the numbers in a range.

2. SUMIF: Sums all the number based on single criteria.

3. SUMIFS: Sums all the numbers based on multiple criteria.

4. SUMPRODUCT: Sums the product of corresponding ranges or arrray.

SUM:

Sums all values from "E2:E10" (UnitCost).

SUMIF:

Sums all the values from UnitCost Where Region is East. Only one criteria can be applied in this function.

SUMIFS:

Sums all the values from UnitCost Where Region is Central and Item is Pencil.

More than one criteria can be applied in this function.

SUMPRODUCT:

Sums all the value by multiplying Units*UnitCost. Multiple ranges can be multiplied by using sumproduct function.