**Function** SUMIF

**Description** Excel SUMIF function adds cell values specified by a given condition or criteria.

**Syntax** SUMIF(range, criteria, [sum_range])

**range **is the range of the array from where the criteria will be matched

**Criteria **the criteria which needs to match.

**[sum_range] **is the range from where the numbers will be added which meets the criteria.

Function SUMIF adds cell specified by a given condition or criteria. Syntax of function SUMIF is **=SUMIF (range, criteria, [sum_range]) **Where **range** is the range of the array from where the criteria will be matched. **[sum_range]** is the range from where the numbers will be added which meets the criteria.

For an example I have created a simple table.

**Example:**

This table has names of the things in one column, next column the group of that name whether it is fruit, vegetable or flower, and in next column it shows the numbers. In the small table F2:G4 I will add the numbers from that specified group.

For that in the G2 cell I have put this formula **=SUMIF(C3:C16,F2,D3:D16)** where **C3:C16** is the **range**, **F2** is the criteria or condition where it will only add the cells from group FRUIT. **D3:D16** is the **[sum_range]**.

Likewise I have added all the VEGETABLES by using **=SUMIF(C$3:C$16,F3,D$3:D$16) **formula.

And added numbers of FLOWERS with the formula **=SUMIF(C$3:C$16,F4,D$3:D$16)**

**Related Video Tutorials:**