Related Tutorial: Expanded Step by Step Excel SUMIF Function Tutorial with Screen Captures
The syntax for the SUMIF function is:
= SUMIF (Range, Criteria, Sum Range)
Range - the group of cells the function is to search.
Criteria - determines whether the cell is to be summed or not.
Sum Range - the data range that is summed if the first range meets the specified criteria. If this range is omitted, the first range is summed instead.
Example Using Excel's SUMIF Function:
- Enter the following data into cells E1 to E6: 114, 165, 178, 143, 130, 165
- Enter the following data into cells F1 to F6: 10, 20, 30, 10, 20, 30
- Click on cell F7 - the location where the results will be displayed
- Click on the Formulas tab of the ribbon
- Choose Math & Trig from the ribbon to open the function drop down list
- Click on SUMIF in the list to bring up the function's dialog box
- In the dialog box, click on the Range line
- Highlight cells E1 to E6 in the worksheet
- On the Criteria line in the dialog box, type "165".
- Click on the SUM Range line
- Highlight cells F1 to F6 in the worksheet
- Click OK to complete the function and close the dialog box
- The answer 50 should appear in cell E7
- Since the criteria of equaling 165 is met by only two cells - E2 and E6 - only the contents of their corresponding cells - F2 and F6 - are summed by the function
- When you click on cell E7 the complete function = SUMIF (D1 : D6 , 165 , E1 : E6) appears in the formula bar above the worksheet