The purpose of the SUMIF function is to add the specified cells by a given criterion.

 

Using SUMIF, you combine 2 functions in one: SUM and IF, you don’t have to worry about 2 syntaxes and a nested formula is not needed.

 

 

 

The SUMIF syntax is basic: = SUMIF (range, criteria, sum_range)

Here is a short description of each argument:

Range: the array you want to evaluate and where you will apply the criterion.
Criteria: selecting a criterion you instruct Excel which cells to add and… Continue to Excel Tutorials for Dummies – SUMIF Function