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.

For example, suppose that in a column that contains numbers, you want to sum only the values that are larger than 5. You can use the following formula: =SUMIF (B2:B25,">5") Tips: If you …

How to use the COUNTIFS function in Excel to apply criteria to cells, across multiple ranges, and count the number of times all criteria are met.

Learn more about the differences. 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 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 …

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 …

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

When you need to perform simple arithmetic calculations on several ranges of cells, sum the results, and use criteria to determine which cells to include in the calculations, consider using …

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 …