SUMIF function allows the aggregation of cells with specified criteria.

The syntax of the function: =SUMIF(range,criteria,[sum_range])

Excel SumIf function

Mandatory argument range is the range of cells you want to estimate the function. Sum_range use the optional argument, if we want to identify the specific cells that will be summed, where the corresponding cell in the field meet the criteria. If omitted, the function suma_zakres will add up all cells in the range.

The criteria argument is used to determine the criteria against which the function will be summarized cells. It is possible to use the criterion in terms of numbers, Boolean expression, or text.

Using SUMIF explains the following example.

Excel SUMIF table

To calculate the sum of people employed in Arizona, the cell type in the formula:


Excel SUMIF formula

As you can see, in this case the range of cells, where we check the criterion (A2: A11) is different from that which we value sum (C2: C11). Please also note that the criterion for entering text, enclose it in quotation marks. In the case of the criterion being the number of quotes can be omitted.

To calculate the total income in units employing more than 450 people, we use the formula:


Excel formula SUMIF function

Like the search text, logical expressions apprehend in quotation marks.