Learn how to use the SUMIF function to sum the values in a range that meet criteria that you specify. See syntax, examples, tips, and limitations of this Excel formula.

The SUMIFS function, one of the math and trig functions, adds all of its arguments that meet multiple criteria. For example, you would use SUMIFS to sum the number of retailers in the country who (1) reside in a single zip code and (2) whose profits exceed a specific dollar value.

Learn how to use the SUMIFS function in Excel to sum values that meet more than one condition, such as region and product. See an example formula, formula autocomplete, and a sample workbook to practice.

This topic provides help for the most common scenarios for the #VALUE! error in the SUMIF/SUMIFS functions.

Lists all math and trig functions, such as the SUM, SUMIF, SUMIFS, and SUMPRODUCT functions.

Use the SUMIFS function when you want to sum values with more than one condition. For instance, you might want to add up the total sales of a certain product, within a certain sales region.

Lists all Excel functions by their category, such as Logical functions or Text functions.

How to create simple formulas in Excel using AutoSum and the SUM function, along with the add, subtract, multiply, or divide values in your worksheet.

You can easily perform mathematical operations with Excel on their own, and in conjunction with Excel functions like SUM. The following table lists the operators that you can use, along with some related functions.

Find Microsoft Excel help and learning resources. Explore how-to articles, guides, training videos, and tips to efficiently use Excel.