Page 111 - Excle-En-V3

19.5.9 - SUMIF:
Returns the sum of values in a range that meet one or more criteria. In a

cell or formula bar, enter the formula where "range" is the range of data you
want to evaluate, "criteria" is the condition that defines the cells to be
summed, and "range-sum" is the data range that includes the cells that will be
summed
=SUMIF(range;criteria;[sum_range])

• Range: The range of cells for which we will set a condition. If the condition is met, it
will sum the corresponding values.

• Criteria: The condition that must be met in order to perform the summation.
• Sum Range: The range of cells containing the values to be summed if the criteria are

met
We can exclude the third part of the SUMIF equation if the conditional range is

the same as the sum range

Figure 156: SUMIF & COUNTIF

103 Central Unit for Information Technology Training - Supreme Council of Universities © Intellectual Property Rights 2024