Excel Function : SUMIFS

Download now!

Excel Function : SUMIFS

Category

Math and trigonometry

Description

Adds the cells in a range that meet multiple criteria

Microsoft Excel Reference Page

https://support.office.com/en-us/article/SUMIFS-function-c9e748f5-7ea7-455d-9406-611cebce642b

Syntax and Description of the SUMIFS Excel Function

The syntax for the SUMIFS function in Microsoft Excel is: =SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...) Arguments sum_range - the range of cells to sum. criteria_range1 - the first range of cells to evaluate for the criteria. criteria1 - the criteria to use on criterion_range1. criteria_range2 - [optional] the second range of cells to evaluate for the criteria. criteria2 - [optional] the criteria to use on criterion_range2. Example =SUMIFS

About SUMIFS Excel Function

The SUMIFS function returns the sum of cells that meet multiple criteria. =SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...) sum_range - The range of cells to sum. criteria_range1 - The first range of cells to evaluate for the criterion. criteria1 - The criterion for the first range. criteria_range2, criteria2, ... - [Optional] Additional ranges and criteria.