SUMIF function in Excel

SUMIF adds the cells that meet one condition.

Syntax

=SUMIF(range, criteria, [sum_range])

Argument	Required?	What it is
range	Required	The cells to check against the criteria.
criteria	Required	The condition, such as "North", ">100" or a cell reference. Text and comparisons go in quotes.
sum_range	Optional	The cells to add up. If left out, the cells in range are added.

=SUMIF(A2:A10,"Laptop",C2:C10) adds the sales in C wherever column A says Laptop.

From the lesson Intro to SUMIF.

Forgetting sum_range, so Excel tries to add the text in the criteria range (result 0).
Typing the criteria value instead of pointing at a cell that holds it.

Type the formula yourself and get it graded instantly, no Excel needed.

SUMIF adds the cells that meet one condition.

=SUMIF(range, criteria, [sum_range])

Argument	Required?	What it is
range	Required	The cells to check against the criteria.
criteria	Required	The condition, such as "North", ">100" or a cell reference. Text and comparisons go in quotes.
sum_range	Optional	The cells to add up. If left out, the cells in range are added.

=SUMIF(A2:A10,"Laptop",C2:C10) adds the sales in C wherever column A says Laptop.

From the lesson Intro to SUMIF.

Forgetting sum_range, so Excel tries to add the text in the criteria range (result 0).
Typing the criteria value instead of pointing at a cell that holds it.

Type the formula yourself and get it graded instantly, no Excel needed.