SUMIFS practice

SUMIFS adds the cells that meet several conditions at once. Below are the 1 Excel exercise on Formuladrill that use it, each checked instantly in your browser.

Syntax

SUMIFS(sum_range, criteria_range1, criterion1, [criteria_range2, criterion2], ...)

What people get wrong

Unlike SUMIF, the range to add comes first. Dates work as criteria with ">="&start.

Excel exercise that use SUMIFS

• Two conditions at onceLevel 2Pro