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], …)

*[sum_range]**A range of cells & values which you want to sum.***criteria_range1**A range from which you want to test criteria.**criteria1**A criteria which can be a number, text, expression, cell reference or a function.**[criteria_range2]**A range from which you want to test criteria.**[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.

In the below example, I have used wildcard characters to specify three different criteria.

- The
**first**criteria range is A2:A9 and criterion is in the cell A12 which will only sum cells which have alphabet O. - 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. - 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.

## Sample File

Download this sample file from here to learn more.

## Remember

- The size of criteria range and sum range should be of the same size.
- You can also use wildcard characters with SUMIFS.
- If you want to sum values on the basis of single criteria, you can use SUMIF.
- If you want to specify criteria in the form of text, you have to use double quotation marks.
- If you skip specifying SUM range it will SUM the values from criteria range which meet the criteria.
- You can only specify criteria up to 255 characters.

*This function is the part of our **top 100 functions list** and here are some **useful formulas** which you can learn today.*

Related Functions

- SUMIF Function: It returns the sum of the numeric values of which meet a condition. You need to specify a condition and [...]
- SUM Function: It returns the sum of the numeric values from range of cells or arrays to which you refer [...]
- SUMPRODUCT Function: It multiplies values from corresponding cells in the given arrays, and returns the sum [...]

Related Tutorials

- SUMIF Between Dates: You can use SUMIF to sum values between two dates using them as a range criteria [...]
- SUMIF OR: SUMIF OR helps use to sum for more than one criteria at the same time which is not possible in normal SUMIF [...]
- SUMPRODUCT IF: And you know the best part? There is no need to use IF function for this. But first [...]

EXCEL HANDBOOK PART 2 – NEW AGE ECONOMICS4 Oct, 18 at 6:24 pm[…] criteria_range1, criteria1, [criteria_range2, criteria2], …) For more understanding, read referencelink . One point I have observed is that the sum_range should be on the right. Do confirm my […]