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

Excel COUNTIF Function Quick Tutorial

Using the COUNTIF Function to Count Data in Selected Ranges


Using Excel's COUNTIF Function

Using Excel 's COUNTIF Function

© Ted French

Related Tutorial: Step by Step Tutorial with Screen Shots -Excel COUNTIF Function

The COUNTIF function, one of Excel's COUNT functions, is used to count up the number of cells in a selected range that meet specified criteria.

The syntax for the COUNTIF function is:

=COUNTIF ( Range, Criteria)

Range - the group of cells the function is to search.

Criteria - determines whether the cell is to be counted or not. This can be a number, expression, cell reference, or text string.

Example: Using Excel's COUNTIF Function

In this example we will count up the number of cells in our data range that contain the number 165.

For help with this example, see the image above.

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

  2. Click on cell E7 - the location where the results will be displayed.

  3. Click on the Formulas tab.

  4. Choose More Functions > Statistical from the ribbon to open the function drop down list.

  5. Click on COUNTIF in the list to bring up the function's dialog box.

  6. In the dialog box, click on the button at the end of the Range line to return to your spreadsheet.

  7. Drag select cells E1 to E6 on the spreadsheet to highlight them.

  8. Click on the button at the end of the Range line to return to the dialog box.

  9. On the Criteria line in the dialog box, type "165" since we are looking for the number of cells containing this number.

  10. Click OK.

  11. The answer 2 should appear in cell E7 since two cells in the range - A2 and A6 - contain the number 165 and, therefore, match the criteria argument.

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

Related Tutorials

©2014 About.com. All rights reserved.