Entering the Sum_range ArgumentThe Sum_range argument is the group of cells that the function is to sum up when it finds a match in the Range argument identified in step 5 of the tutorial.
This argument is optional and, if omitted, Excel adds the cells that are specified in the Range argument.
Since we want the total sales for Sales Reps with more than 250 orders we use the data in the Total Sales column as the Sum_range argument.
For help with these instructions, click on the image above.
- Click on the Sum_range line in the dialog box.
- Drag select cells E3 to E12 on the spreadsheet to enter these cell references as the Sum_range argument.
- Click OK to close the dialog box and complete the SUMIF function.
- An answer of zero should appear in cell E12 - the cell where we entered the function - because we have not yet added the data to the Criteria field (D12).
Once data is entered into cell D12 in the next step, if the Range field of a record contains a match for the criteria in D12 - the data in the Total Sales field for that record will be added to the total by the function.