SUMIFS function

Excel SUMIFS Function is a powerful tool for adding up numbers in a range that meets multiple criteria. It’s like a filter that selects specific data and then adds up only the values that match those criteria. Let’s break down how to use this function step by step.


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


rangeThe range of numbers you want to sum based on the given criteria.
criteria_range1The first range where you want to apply a condition.
criteria1The condition you want to apply to the first range.
[criteria_range2, criteria2](Optional) Additional ranges and criteria you want to apply. You can have multiple pairs of criteria_range and criteria.

How to use

Let’s see how to use the SUMIFS function with some examples:

Suppose you have a table of sales data with two columns: “Product” and “Sales.” You want to find the total sales for a specific product, for instance, “Apples.”

This formula adds up all the sales in the “Sales” column where the corresponding “Product” column matches “Apples.”

If you want to find the total sales for “Apples” and “Oranges,” you can use multiple criteria:

The formula sums the sales for both “Apples” and “Oranges” from the “Sales” column.

If you need to apply different criteria for two different ranges, you can do that as well. For example, to find the total sales for “Apples” in January and “Oranges” in February:

By using multiple pairs of criteria_range and criteria, you can perform more complex analyses on your data.


Excel SUMIFS Function is a versatile way to sum values that meet specific criteria. You can use it to filter and calculate the sum based on various conditions, making it a valuable tool for data analysis and reporting.

Tomasz Decker is an Excel specialist, skilled in data analysis and financial modeling.