excel formulas sumif examples

SUMIF

What Does It Do ?

This function adds the value of items which match criteria set by the user.

Syntax

=SUMIF(RangeOfThingsToBeExamined,CriteriaToBeMatched,RangeOfValuesToTotal)

=SUMIF(C4:C12,"Brakes",E4:E12)

This examines the names of products in C4:C12.
It then identifies the entries for Brakes.
It then totals the respective figures in E4:E12

=SUMIF(E4:E12,">=100") 

This examines the values in E4:E12.

If the value is >=100 the value is added to the total.

Formatting

No special formatting is needed.