Advanced Aggregation: The SUMIFS Formula

The SUMIFS formula is one of the most powerful functions for granular data analysis. It allows you to sum values in a range that meet multiple, specific criteria across different columns. For example, if you need to sum the total sales for a specific product AND a specific salesperson AND a specific month, SUMIFS handles this logic effortlessly.

How it Works?

The function requires the sum_range to be defined first, followed by pairs of criteria ranges and their respective criteria. All criteria must be met for a cell to be included in the final aggregation.

Example

To sum revenue in column A where column B is 'East Region' and column C is 'Category A': =SUMIFS(A:A, B:B, "East Region", C:C, "Category A")

Interactive Excel Demo