Watch Video - Excel Formula Tutorial | All Excel Tutorial Videos
Summary - The Excel SUMIF function returns the sum of cells that meet a single condition. Criteria can be applied to dates, numbers, and text. The SUMIF function supports logical operators (>,<,<>,=) and wildcards (*,?) for partial matching.
Purpose - Sum numbers in a range that meet supplied criteria
Return value - The sum of values supplied.
Syntax - =SUMIF (range, 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.
Watch Video - Excel Formula Tutorial | All Excel Tutorial Videos