1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

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

© Ted French

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.

©2014 About.com. All rights reserved.