Categories
Excel Microsoft Office

Excel Functions: SUM, SUMIF and SUMIFS

There are many functions in Excel to do the addition of numbers in two or more cells. Of all these functions in Excel to add values, the most widely used functions are: SUM, SUMIF and SUMIFS. Let’s understand more about these functions and learn how to use them in Excel.

I’ve created a table in Excel that you can see in the image below, you can also create a table like this. We’ll use the SUM functions on this table.

SUM( )

When we have to add two or more numbers without any condition, we will use SUM( ).

Example:

In the table above, if we have to find total Sales amount, we’ll use:

= SUM(F3:F7)

The result will be ₹ 98,200.00

SUMIF( )

SUMIF function will add only those numbers in the cell range that match with the one condition we enter in the function.

Please note: The condition will be on the same column on which addition will be performed.

Example:

If we have to add only those Sales amount, that are more than ₹ 10,000.00 then we’ll use SUMIF as:

=SUM(F3:F7,”>10000″)

The result will be ₹ 87,000.00

SUMIFS( )

In SUMIFS function, we can give condition using multiple columns.

Example:

If we have to add only those amount, that are from Fashion category and also from Clothing sub-category, then we’ll use SUMIFS as:

=SUMIFS(F3:F7,D3:D7,”fashion”,E3:E7,”clothing”)

The result will be ₹ 1,500.00

I have also included all the formula below the table so that it can be easy for you to understand the difference in the functions.

I hope the above article was helpful for you to understand the SUM, SUMIF and SUMIFS functions in Excel. If you’ve any doubt, please share it through comments.

Leave a Reply

Your email address will not be published. Required fields are marked *