How to Calculate Empty Cells Using Excel


In many situations, cells in a spreadsheet are left blank to indicate zero value. It is easy to count a few blank cells on an an excel spreadsheet. For example, if there are only 10 numbers on a spreadsheet and two of them are left blank, we can simply count blank cells by looking at it. However, when there are thousand of numbers on a spreadsheet, counting blank cells manually is not practical. An easy way to determine the number of blank cells in a column or row is to use use the excel Countblank function.

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

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

  • Click "Insert Function" on the top left-hand side of the Excel spreadsheet. The "Insert Function" window will pop open.

  • Click on the drop-down menu of "Or Select a Category."

  • Scroll down to the "Select a Function" window. Choose "Countblank."

  • 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."

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

Tips & Warnings

  • When the blank count has been completed, check twice to ensure your obtained value is correct.
  • Checking twice will take less than a minute, so don't hesitate to double-check for accuracy.

Related Searches

Promoted By Zergnet



You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!