SUMIF (Adds the cells specified by a given criteria)

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 required.