# How to use SUMIFS Function in Excel

The SUMIFS function can sum values which meet multiple criteria.

In simple words, you can specify more than one criteria to check and get SUM of values where criteria are matched.

## Syntax

SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)

1. [sum_range] A range of cells & values which you want to sum.
2. criteria_range1 A range from which you want to test criteria.
3. criteria1 A criteria which can be a number, text, expression, cell reference or a function.
4. [criteria_range2] A range from which you want to test criteria.
5. [criteria2] A criteria which can be a number, text, expression, cell reference or a function.

## Examples

In the below example, we have used three different criteria to check and it has returned the sum of the values which meet those criteria.

1. The first criteria range is A2:A9 and criterion is in the cell A12 which will only sum cells which have alphabet O.
2. The second criteria range is B2:B9 and criterion is in cell B12 which will only sum cells which have alphabet P. It will apply to all the cells which met the condition 1.
3. The third criteria range is C2:C9 and criterion is in cell C12 which will sum cells with any type of value. It will apply to all the cells which met the condition 1 and 2.

## Remember

### 1 thought

1. Pingback: EXCEL HANDBOOK PART 2 – NEW AGE ECONOMICS