The SUMIF Function's Syntax
The syntax for the SUMIF function is:
= SUMIF ( Range, Criteria, Sum_range )
The SUMIF Function's Arguments
Range - the group of cells the function is to search.
Criteria - this value is compared with the data in the Range cells. If a match is found then the corresponding data in the sum_range is added up. Actual data or the cell reference to the data can be entered for this argument.
Sum_range (optional) - the data in this range of cells is added up when matches are found between the range argument and the criteria. If this range is omitted, the first range is summed instead.
Return to Index page