Excel SUMIF function

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 rangeF2 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: