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


COUNT Blank Cells in a Selected Range in Excel


Excel COUNTBLANK Function

Excel COUNTBLANK Function

The COUNTBLANK functionis used to count up the number of blank cells in a selected range of data.

The syntax for the COUNTBLANK function is:


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

Example: Count Blank Cells with the COUNTBLANK Function

  1. Enter the following data into cells as shown in the image above:

    D1 - cabbages , D2 - carrots
    D3 - leave blank , D4 - radishes
    D5 - potatoes , D6 - parsnips

  2. Click on cell E1 - 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 COUNTBLANK in the list to bring up the function's dialog box.

  6. Drag select cells D1 to D6 on the spreadsheet to enter the range into the dialog box.

  7. Click OK.

  8. The answer "1" should appear in cell E1 since there is only one blank cell ( D3 ) in the range D1 to D6.

  9. When you click on cell E1 the complete function =COUNTBLANK ( D1 : D6 ) appears in the formula bar above the worksheet.

©2014 About.com. All rights reserved.