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