Excel: Count empty cells - how it works

In Excel, you can count the empty cells using a short formula. This way you know if you have large amounts of data if you have forgotten a value somewhere. We will show you which formula that works and give you an example.

Count empty cells in Excel

• The formula in Excel is "NUMBER OF EMPTY CELLS".
• First click in the cell in which you want to see the number of empty cells.
• Then enter: = NUMBER OF EMPTY CELLS (FROM_CELL: TO_CELL) and press the [Enter] key.
• Explanation: With "VON_Zelle" and "BIS_Zelle" you stake out the area in which Excel should search for empty cells.
• Example for a range: For all cells from A1 to A100 enter "= NUMBER OF EMPTY CELLS (A1: A100)".
• Example for several areas: For the cells from A1 to A100 as well as B2 to D60 and E5 to G50 enter "= NUMBER OF EMPTY CELLS (A1: A100; B2: D60; E5: G50)".
• Tip: If you want to mark several sections in which Excel should search for empty cells, first select the first section, then hold down the [Ctrl] key and mark all other sections.

Next, we will show you how to add or subtract numbers and letters in Excel.