SUMIF & SUMIFS
SUMIF and SUMIFS formulae are formed by combining SUM and IF Functions.
The SUM function has the capability to add items, and SUMIF function extends the capabilities of SUM function by giving you the choice to SUM only those items that meet a particular criteria.
The SUM function has the capability to add items, and SUMIF function extends the capabilities of SUM function by giving you the choice to SUM only those items that meet a particular criteria.
SUMIF Function:
=SUMIF(range, criteria [, sum_range])
|
SUMIFS Function:
=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)
|
Practice Task File |
![]()
|