# Excel: Counting, if not empty - that's how it works

24 views
in Office
reopened
Excel: Counting, if not empty - that's how it works

by (1.6m points)

How to count all cells in Excel that are not blank
1st step:
2nd step:
3rd step:
quick start Guide

Do you want to ignore the blank cells when counting cells in Excel? We show which function works..

Excel functions make your life easier. Would you like to know how many times a particular item has been sold? The COUNTIF function offers exactly this range of functions. But there is also a simplified function in Excel with which you only read out the cells with values ​​that are not empty. You can find out which one is in the following article.

### How to count all cells in Excel that are not blank

It doesn't always have to be the slightly more complex COUNTIF function. With the "NUMBER2" function, you can conveniently count all cells that are not empty. It doesn't matter whether the cells contain text or numbers. Follow our step-by-step instructions or take a look at the brief instructions .

### quick start Guide

1. Open an Excel spreadsheet with missing, blank cells.
2. Specify the range of cells you want to count - for example B2: B7.
3. Then select the cell in which the result should appear.
4. As a last step, enter the following formula in the formula bar above: " = NUMBER2 (B2: B7) ". Adjust the cell range accordingly. Confirm the formula with [Enter] .