Excel SUMIF FUNCTION

Excel SUMIF FUNCTION

The Excel SUMIF function returns the sum of cells that supplied criteria. Criteria can be applied to dates, numbers, and text using logical operators (>,<,<>,=) and wildcards (*,?) for partial matching.

Syntax 

=Sumif(Rage, Criteria.[sum_range])

     Arguments ·        range - The range of cells that you want to apply the criteria against.
·        criteria - The criteria used to determine which cells to add.
·        sum_range - [optional] The cells to add together. If sum_range is omitted, the cells in range are added together instead.

Examples

=sumif(Gender,"Male",Salary)

=sumif(Salary, “>200”,Salary)