• Share

# Excel SUMIF Function Step by Step Tutorial

#### 3 of 8

The SUMIF Function's Syntax

The SUMIF Function's Syntax

### The SUMIF Function's Syntax

In Excel, a function's syntax refers to the layout of the function and includes the function's name, brackets, and arguments.

The syntax for the SUMIF function is:

= SUMIF ( Range, Criteria, Sum_range )

### The SUMIF Function's Arguments

The function's arguments tell the function what condition we are testing for and what range of data to sum when the condition is met.

Range - the group of cells the function is to search.

Criteria - this value is compared with the data in the Range cells. If a match is found then the corresponding data in the sum_range is added up. Actual data or the cell reference to the data can be entered for this argument.

Sum_range (optional) - the data in this range of cells is added up when matches are found between the range argument and the criteria. If this range is omitted, the first range is summed instead.

Ted French