SUM Functions Skill Summary

Freeintermediate 20 min4 tasks0/48 pts

Time to mix everything: SUM for plain totals, SUMIF for one condition and SUMIFS for several. Pick the simplest function that does the job, and check which argument is the sum range.

Syntax

SUM(…) · SUMIF(range, criteria, [sum_range]) · SUMIFS(sum_range, range1, criteria1, …)

Common mistakes

Using SUMIF when two conditions are needed.
Mixing up the argument order of SUMIF and SUMIFS.
A range that stops one row short.

SUMIFS Function SUMIF Practice