Related Tutorial: Step by Step Tutorial with Screen Shots - Excel SUMIF Function
The SUMIF function is used to add up the values in cells in a selected range that meet certain criteria.
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.
- Drag select cells E1 to E6 on the spreadsheet.
- On the Criteria line in the dialog box, type "165".
- Click on the SUM Range line.
- Drag select cells F1 to F6 on the spreadsheet.
- Click OK.
- The answer 50 should appear in cell E7. Since the criteria of equaling 165 is met by only two cells - E2 and E6, only their corresponding cells - F2 and F6 are summed. The sum of 20 and 30 is 50.
- When you click on cell E7 the complete function = SUMIF (D1 : D6 , 165 , E1 : E6) appears in the formula bar above the worksheet.
Other Quick Tutorials
