HOW TO USE “SUMIF “FORMULA IN EXCEL

HOW TO USE SUMIF FORMULA IN EXCEL


SUMIF is used to sum the set of values using a given criteria within a range of values. Let’s assume that there are students with the same score in a subjectand want to add their values altogether.

. The  SUMIF function allow excel to add only cells that meet criteria you choose. The first step is to type SUMIF in a blank cell and select it.Type = SUMIF(A1:C16,”32″), after which you press enter.                          

The range is the range of cells you want to apply the formula to. The criteria is the common value that you want to add up. The sum range is used depending on the kind of table. This means that the sum range is used when a table has more than one column that has to be added up. Look at the table below.

You will notice that this table has two columns that you wish to find the SUMIF for. In this case you can include the sum range in the inputing of the formula.

 In this case the sum range is the table but without the heading.