SUMIF & Sum Range

Freebeginner 15 min4 tasks0/48 pts

In SUMIF(range, criteria, [sum_range]) the range is checked against the criteria and the sum_range holds the numbers to add. Leave out sum_range and Excel adds the range itself, which is handy for conditions like ">1000". The criteria can also point at a cell, so changing that cell changes the answer.

Syntax

SUMIF(range, criteria, [sum_range])

Example: =SUMIF(B2:B10,"South",C2:C10) adds column C wherever column B says South. =SUMIF(C2:C10,">1000") adds the big sales themselves.

Common mistakes

Giving sum_range the same-size range, but shifted by a row.
Adding the text column instead of the numbers (result 0).
Typing the criteria by hand when a cell already holds it.

Wildcard Characters SUMIFS Function

Topics/Sum and Count Functions

SUMIF & Sum Range

Freebeginner 15 min4 tasks0/48 pts

Syntax

SUMIF(range, criteria, [sum_range])

Example: =SUMIF(B2:B10,"South",C2:C10) adds column C wherever column B says South. =SUMIF(C2:C10,">1000") adds the big sales themselves.

Common mistakes

Giving sum_range the same-size range, but shifted by a row.
Adding the text column instead of the numbers (result 0).
Typing the criteria by hand when a cell already holds it.

Wildcard Characters SUMIFS Function