What is SUMIF Function?The Excel SUMIF function finds the values in a supplied array, that satisfy a given criteria, and returns the sum of the corresponding values in a second supplied array.
When to use SUMIF?SUMIF Function is used to add the specified cells based on the single or multiple supplied criteria. Sometimes we require conditional sum in Excel then we can use this function to add all numbers in a particular given range. SUMIF function is based on the three parameters- range, criteria, and sum_range. Every parameter has own functionality and also depends on SUMIF multiple criteria. Read More: List Of Excel Keyboard Shortcuts with Formula For Beginner
Function SyntaxThe SUMIF Function in Excel has the following syntax: =SUMIF(range, criteria, sum_range) Parameters range: The range of cells that you want to apply the criteria against. criteria: The criteria used to determine which cells to add. sum_range: Optional. It is the range of cells to sum together. If this parameter is omitted, it uses range as the sum_range. Now, let see how to use SUMIF in excel with a Case Study. Case Study: Consider that we have a shop and 5 people have ordered goods from us. Some people have paid us, but some haven’t. We want to calculate how much in total has been paid to us and how much is still owed. Read More: 5# Powerful tricks to format cells in Excel We can do it using SUMIF. Let’s go through the following steps. Step 1: Open Excel sheet and from Row 1, create three columns named Customer, Product Price and Payment Status. Enter data under these 3 columns as shown in the above picture. Here we will calculate:
- Total Paid Price (Cell A10)
- Total Due Price (Cell A11)
- Sum of product prices that sold over $100 (Cell A12)