How to Use Sum iF Function in excel

Sometimes you might not want to add all the values in excel. For example you are given a set of data and you just want to add those values which are greater then 50.

Formula: =SUMIF(range,criteria,sum range)

Criteria: represents what you want to the excel to sum. for example for excel to sum only values greater then 50 in the creteria box you will write ">50" (inverted commas included)

The sum range represent the range from which you wanna search for numbers greater then 50.


the Picture in the left represents the Formula used in A14 cell of excel i.e. is the SUMIF formula for values greater then 50.