How to Count the Number of Blank Cells in a Range in Excel 2013


When entering data into a spreadsheet in Microsoft Excel 2013, it is not uncommon to have blank spaces that are missing data. On small spreadsheets, or in small ranges of cells, it can be easy to manually count the missing spaces. Unfortunately it is much more difficult as the spreadsheet gets larger, and it can be frustrating to keep an accurate count as you are scrolling down the sheet.

Excel 2013 has a function that can help with this problem by automatically counting the number of blank cells that exist in a range which you specify. Our guide below will show you how to use this function.

 

Counting the Number of Blank Cells in a Range in Excel 2013

The steps in this article will show you how to use the function COUNTBLANK in your Excel spreadsheet. Using this function will provide you with a count of the number of blank cells within a range that you specify.

Here is how to count the number of blank cells in a range in Excel 2013 –

  1. Open your spreadsheet in Excel 2013.
  2. Click inside a blank cell where you would like to display the number of blank cells that fall in the range you will specify.
  3. Type the formula =COUNTBLANK(XX:YY). Replace XX with the first cell in your range, and YY with the last cell in the range. Press Enter on your keyboard when you are finished. The displayed number of the number of blank cells in the range you selected.

 

These steps are show below with pictures –

Step 1: open your worksheet in Excel 2013.

 

Step 2: Click inside a blank cell where you will enter the formula and display the number of blank cells.

click inside a blank cell

 

 

Step 3: Type the formula =COUNTBLANK(XX:YY) where XX is the first cell of the range, and YY is the last cell of the range. In the picture below, I want to see how many blank cells are in the range C2:C6. You can then press Enter on your keyboard to execute the formula.

enter the countblank function

 

 

Another very helpful function in Excel 2013 is CONCATENATE. Learn how to use it to combine cells from multiple columns. This can save a lot of annoying data entry or copying and pasting.

solveyourtech.com newsletter
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.