How to Calculate Empty Cells Using Excel

1. Add the following numbers and blank cells in the first column of your Excel 2007 document. For example, add the numbers 2,3,leave blank,5,6,7,leave blank,9,0,2,3,4,leave blank,6,7, and 8 in A2, A3, A4, A5, A6, A7, A8, A9, A10, A11, A12, A13, A14 and A15. Here 'leave blank' means don't enter any value in A3, A7 and A13.
2. Click on the 'A17' cell for this example. This is the cell where you will calculate how many total blank cells are in this column. You can choose any cell to calculate total blank cells.
3. Click 'Insert Function' on the top left-hand side of the Excel spreadsheet. The 'Insert Function' window will pop open.
4. Click on the drop-down menu of 'Or Select a Category.'
5. Scroll down to the 'Select a Function' window. Choose 'Countblank.'
6. Click 'OK.' The 'Functions Arguments' window will open. Ensure that on 'Number 1' cell, A2:A15 is populated. If A2:A15 is not populated, enter A2:A15 manually. Click 'OK.'
7. The total blank cells for the row has been successfully calculated in the 'A17' cell. In this example, the calculated value of blank count is '3'. In other words, only three cells are blank on this column. You can use this method to accurately identify blank cells regardless of the size of the data.