SUMIFS function



Version Availability:

Desktop version starting Excel 2007

Google Sheets

Excel for Web

Function Type: Math and Trigonometry

Description:

SUMIFS function adds the cells specified by a given set of conditions or criteria. It is the plural version of the SUMIF function because it can accommodate more than 1 criteria.

Function Structure: 

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

Argument Breakdown:

sum_range – This is the actual range of cells to sum.

criteria_range1– This is the range of cells you want evaluated for the particular condition or criteria.

criteria1 – This is the condition or criteria in the form of a number, expression, or text that defines which cells will be added. This can be a) Numeric criteria, b) Text criteria, c) Date criteria, d) AND criteria and e) OR criteria.

criteria_range2 – This is the range of cells you want evaluated for the particular condition or criteria. This is optional when you will need to set more than 1 condition.

criteria2 – This is the condition or criteria in the form of a number, expression, or text that defines which cells will be added. This can be a) Numeric criteria, b) Text criteria, c) Date criteria, d) AND criteria and e) OR criteria. This is optional when you will need to set more than 1 condition.

… – This argument means that you can add more arguments.

*Please note that the square brackets before and after of this arguments[criteria_range2, criteria2] mean that these are optional, but they go together.

Example:

The formula for E19 =SUMIFS(E3:E16,B3:B16,B19)

This means that IF the value in cells B3:B16 is equal to B19 which is “February”, then Excel will add the corresponding value in cells E3:E16.



Published by Cash Heaven

Excel Expert and Financial Analyst Excel / Google Sheets / Financial Modelling, Valuation and Analysis Effective communicator / High quality / Affordable / Reliable / Quick Turnover I've successfully completed over 200 financial modelling, valuation and analysis projects with start-up stage and corporate companies over the past 4 years. I love to solve problems, have an eye for design, and have built business excel templates. I fix Excel formulas in 10 minutes.

One thought on “SUMIFS function

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: