You use the SUMIF function to sum the values in a range that meet criteria that you specify. For example, suppose that in a column that contains numbers, you want to sum only the values …

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 …

Sum values based on one or more conditions by using the SUMIFS function in a formula.

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.

Learn these top skills to create your own formulas and functions.

Use the SUMIF function when you want to sum values with one condition. For example, when you need to add up the total sales of a certain product. Use the SUMIFS function when you want to …

How to use AutoSum in Excel to add numbers in a column or a row of numbers.

Sum every Nth value in a range of values. The following examples show you how to create multi-cell and single-cell array formulas. Where possible, we’ve included examples with some of the …

Detect errors in formulas. Lists all Excel functions by their category, such as Logical functions or Text functions.

Lists all statistical functions, such as the AVERAGE, COUNTBLANK, and MEDIAN functions.