What Does It Do?
This function adds the value of items which match criteria set by the user.
Syntax
=SUMIF(Range Of Things To Be Examined, CriteriaToBeMatched, RangeOfValuesToTotal)
=SUMIF(C4:C12,”Brakes”,E4:E12)
=SUMIF(E4:E12,”>=100″)
Formatting
No special formatting is needed.