Loading…
Loading…
SUMIF adds the cells that meet one condition. range is where Excel checks the condition, criteria is the condition, and sum_range holds the numbers to add.
Syntax
SUMIF(range, criteria, [sum_range])
Example: =SUMIF(A2:A10,"Laptop",C2:C10) adds the sales in C wherever column A says Laptop.
Common mistakes
Read the lesson, then try it yourself in a live spreadsheet.