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):
- 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.
- Down in the status bar shows you Excel now next to the average value and the number of cells that have a content.
- 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.
If you want to see using a formula in an Excel cell, the counted lines is as follows:
- Click in the cell where you want to display the number of cells counted.
- If you (whether text or number) want to count all cells with values you type in = number2 (B2: E5)
- If you want to count only those cells that have the numbers, it uses instead the formula = COUNT (B2: E5)
- then press enter.
- In the line, the number of cells counted your area will appear.
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
Posted In: software