SUMIF Function in Excel

In this post, let’s learn how the SUMIF function works in excel, describe the formula syntax, and how you can use the SUMIF function in an excel spreadsheet. 

What is SUMIF Function in Excel? 

The SUMIF Function in Excel is used to sum the values in a range when it meets a certain criterion that you specified. 

Syntax of SUMIF Function 

=SUMIF (range, criteria, [sum-range]) 

Parameter 

  • Range– (Required) The range of cells that was evaluated by criteria. 
  • Criteria– (Required) The criteria are used to determine the cells to be added. 
  • Sum_range– (Required) The cells to be added together. 

Example 

=SUMIF (A2:A9,”>50”)              

=SUMIF (G6:G10,”>90”) 

How to use SUMIF Function in Excel? 

The following steps will explain the work of the SUMIF function in an excel spreadsheet

  • First, prepare an excel sheet with the specified details in it, or open an existing excel sheet.   
  • In the Formulas ribbon, you can see the Auto sum command in it click it a drop-down box will appear, in that choose more functions. 
  • Home->Auto sum->More Functions 
How to use SUMIF Function in Excel? 
  • An insert function dialogue box appears with a drop-down list of various function that choose SUMIF Function in it. 
  • Insert Function->SUMIF->ok  
How to use SUMIF Function in Excel? 
  • After that “ =SUMIF( “ appears in the cell where you want to display the result of the SUMIF Function. 
How to use SUMIF Function in Excel? 
  • In cell A3 the result of the SUM of the range between B2:B8 calculates the values that are more than 100. The syntax we have used is “ =SUMIF (B2:B8,”>100″)” 
How to use SUMIF Function in Excel? 

SUMIF NOT EQUAL TO  

To perform not equal to criteria use the “<>” operator within double-quotes. 

How to use SUMIF Function in Excel? 

Note: 

  • The SUMIF Function only supports one condition. 
Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Hey, wait!Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.