SUMIF
What Does It Do ?
=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
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.
