• Share
Send to a Friend via Email

### Your suggestion is on its way!

An email with a link to:

was emailed to:

Thanks for sharing About.com with others!

# Excel SUMIFS Function Step by Step Tutorial

#### 3 of 10

The SUMIFS Function's Syntax

The SUMIFS Function's Syntax

### The SUMIFS 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 SUMIFS function is:

= SUMIFS (Sum_range, Criteria_range1, Criteria1, Criteria_range2, Criteria2, ...)

Note: Up to 127 Criteria_range / Criteria pairs can be specified in the function.

### The SUMIFS Function's Arguments

The function's arguments tell the function what conditions are being tested for and what range of data to sum when those conditions are met.

All arguments in this function are required.

Sum_range - the data in this range of cells is summed when a match is found between all specified Criteria and their corresponding Criteria_range arguments.

Criteria_range - the group of cells the function is to search for a match to the corresponding Criteria argument.

Criteria - this value is compared with the data in the corresponding Criteria_range. Actual data or the cell reference to the data can be entered for this argument.

Ted French