1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Excel SUMIF Function Quick Tutorial

Using the SUMIF Function to Total Data in Selected Ranges


Excel SUMIF Function

Excel SUMIF Function

Excel SUMIF Function

The SUMIF function is used to add up the values in cells in a selected range that meet certain criteria.

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:

  1. Enter the following data into cells E1 to E6: 114, 165, 178, 143, 130, 165

  2. Enter the following data into cells F1 to F6: 10, 20, 30, 10, 20, 30

  3. Click on cell F7 - the location where the results will be displayed

  4. Click on the Formulas tab of the ribbon

  5. Choose Math & Trig from the ribbon to open the function drop down list

  6. Click on SUMIF in the list to bring up the function's dialog box

  7. In the dialog box, click on the Range line

  8. Highlight cells E1 to E6 in the worksheet

  9. On the Criteria line in the dialog box, type "165".

  10. Click on the SUM Range line

  11. Highlight cells F1 to F6 in the worksheet

  12. Click OK to complete the function and close the dialog box

  13. The answer 50 should appear in cell E7

  14. 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

  15. When you click on cell E7 the complete function = SUMIF (D1 : D6 , 165 , E1 : E6) appears in the formula bar above the worksheet

©2014 About.com. All rights reserved.