Excel SUMIF Function


Home >> How to Use Excel Tutorial >> Excel Formulas List >> Excel SUMIF Function



In this tutorial, you will learn how to use the excel SUMIF function. The way to use the SUMIF formula in excel begins by understanding some things first. These things are the criteria and the numeric table where the sum will be done based on the criteria.

This is important so your numbers will be processed appropriately by the SUMIF function in excel. Make sure about them before you put your inputs in this formula.


Why do We Need to Learn About Excel SUMIF Formula?


In the sum operation on a spreadsheet file, sometimes we don’t want to do the process on all numbers. In this case, we only want to sum the numbers that fulfill a logic condition based on our processing needs.

An example of this need is like when we want to get the total spent money in a spending post. Or probably when we want to calculate the market potential of a particular customer segment. In these two cases, we need a specific method so we can get the calculation result that we need. When we have many numbers, it will be hard to do the sum process based on our criteria manually.

To solve this problem, there is the excel SUMIF formula that we can use. Using this formula, the sum process based on a certain logic condition can be done much easier, faster, and more accurate. What is SUMIF formula in excel and its usage will be explained deeper in the next parts of this tutorial. Learn excel SUMIF function so you can be better at doing the sum process in your spreadsheet file!


What is Excel SUMIF Function?


Excel SUMIF function is a function that can be used to sum numbers that fulfill a certain logic condition. This function separates between the cell range where the criteria is evaluated and the cell range where the numbers are. This is because the data to be evaluated often has a different location from the numbers that we want to add.

A brief explanation about the inputs in the formula is as follows:


=SUMIF(range, criteria, sum_range)


Note:
  • range = the cell range where the data evaluation based on your criteria takes place
  • criteria = the criteria that you want to use
  • sum_range = the cell range where the numbers to be summed are if their data entries are fit your criteria



How to Use SUMIF Formula in Excel?


The following will explain how to use the excel SUMIF function. The input of the cell range where the evaluation is done and where the numbers are must be inline. This is so the sum process won’t confuse you when you want to get the result that you want.


Using SUMIF


  1. Type equal sign ( = ) in the cell where you want to put the result in

    Excel SUMIF Function - Screenshot of Step 1

  2. Type SUMIF (can be with large and small letters) and open bracket sign after =

    Excel SUMIF Function - Screenshot of Step 2

  3. Drag cursor on the cells where the logic condition will be evaluated and type comma sign ( , )

    Excel SUMIF Function - Screenshot of Step 3

  4. Input your criteria then type comma sign. The criteria must be inside quotes sign ( “” ) if it is for text. The quotes sign must be there too if the criteria is more than/less than criteria for numbers

    Excel SUMIF Function - Screenshot of Step 4

  5. Drag cursor on the cells where the digits which you want to sum are in. The cell of the digits must be inline vertically/horizontally with your logic condition cells. They should also have the same number of cells

    Excel SUMIF Function - Screenshot of Step 5

  6. Type close bracket sign after all the numbers or cell coordinates filled with numbers that you want to process have already been inputted

    Excel SUMIF Function - Screenshot of Step 6

  7. Press Enter
  8. The process is done!

    Excel SUMIF Function - Screenshot of Step 8



Exercise


After you have learned how to use the excel SUMIF function, you can practice your understanding through the exercise below!

Download the exercise file and answer the following questions. Download the answer key file if you have done the exercise file and sure about your answers!

Link to the exercise file:
Download here

Questions

  1. What is the total sales of product A?
  2. What is the total sales of products in region 1?
  3. What is the total sales of product B and C (Hint: for “not the same as" criterion, use <> sign)

Link to the answer key file:
Download here


Additional Note


If you have more than one criteria for your sum process, then you cannot use excel SUMIF function. Instead, you need to use SUMIFS. The explanation on SUMIFS can be learned in another tutorial from Compute Expert.



Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!


Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!



Follow our tutorial content also on


CONTACT US PRIVACY POLICY TERMS AND CONDITION AFFILIATE DISCLOSURE @Compute Expert