Summing amounts in Excel depending on multiple conditions using SUMIFS

Do you have a set of data in Excel and you want to sum a certain amount depending on multiple conditions? Then you can use the function SUMIFS. I’ll give you an example to illustrate this situation better.

Let’s say you have a T-shirt shop and have sales data saved in an Excel spreadsheet. Let’s assume that you want to know the total sales amount of Black, Male T-shirts. See the example below.

The formula used here is: =SUMIFS(C:C;F:F;”Black”;G:G;”Male”)

Now let’s explain this a bit. The SUMIFS function syntax is as follows:

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

So in this case the sum_range is the C column, the criteria_range1 is the F column and the criteria1 to count in this cell range is “Black”. The criteria2_range is the G column and the criteria2 is “Male”. You have to define at least the sum range and one criteria range / criteria combination. Any extra range/criteria combination is optional. You can add up to 127 range/criteria combinations.

Related posts:

Counting items in Excel with multiple conditions using COUNTIFS
Excel IF function with multiple conditions using the OR function