Excel: Cell count – Here’s how

In Excel you can count cells that have a content, and those that are empty. I show how you can count your cells in Excel with and without formulas.

video | 5 Excel tips for professionals

First, I show how you can count the cells of a specific area easily in Excel. After that, the guide is, as you can also output in an Excel cell, the number of cells counted. Finally, you see how you can even empty cell count.

Note: I use Excel 2016. For older versions, the instructions may vary slightly.

Excel: Cell count - no formula

In Excel you can quickly count the cells of rows and columns. Here Excel counts all cells that have a content (text, numbers):

  1. Highlighted in Excel left at the edge of all lines (1,2,3, &# 8230;) or above at the edge of all of the columns (A, B, C, &# 8230), the cells of which want to include her.

    Two marked lines: Excel displays the number of cells that have the capacity to below.Two marked lines: Excel displays the number of cells that have the capacity to below.

  2. Down in the status bar shows you Excel now next to the average value and the number of cells that have a content.
  3. You can select with the mouse only a specific section - about B2 to E8. Excel displays the number of cells described in here.

As you count only cells with values, learn it later.

Cell count - with formula

In our example, we have a small table whose range of B2 goes to E5. we choose this area from below to allow the cells to count - and once all cells that have a value and once only the cells that contain numbers.

Excel Example: We want to count all cells in the range B2 to E5 and output them in a cell.

If you want to see using a formula in an Excel cell, the counted lines is as follows:

  1. Click in the cell where you want to display the number of cells counted.
  2. If you (whether text or number) want to count all cells with values ​​you type in = number2 (B2: E5)
  3. If you want to count only those cells that have the numbers, it uses instead the formula = COUNT (B2: E5)
  4. then press enter.
  5. In the line, the number of cells counted your area will appear.
Excel gives us the number of cells with numbers. Above you see the corresponding formula.

count blank cells in Excel

If you want to count blank cells in Excel, you go exactly as in the above instructions. However, their use as our example the formula:

  • COUNTBLANK (B2: E5)

You can by the way in Excel to do the following:

  • Excel: simply explained SUM (function)
  • Using Excel to calculate average in easy steps


  1. Excel: NUMBER and COUNTIF – Certain values ​​are
  2. Using Excel to calculate average in easy steps
  3. Excel: Convert Text to Number – Here’s how
  4. Excel: “If cell (not) empty, then …” – function
  5. Excel: line break in a cell cause – Here’s

14.11.2017

Posted In: software

map