How to count non-blank cells in Excel?

Who I am
Pau Monfort
@paumonfort
Author and references
In Microsoft Excel, the user may need to know the name of cells non vines, ie which contain values. This can be useful for counting a large amount of cells with ease. Here are several methods to quickly calculate empty or non-empty cells in an entire document, a table as well as one or more rows or columns in Excel.

1. Calculation formulas

Excel provides several formulas to count the number of blank cells or those containing values.

One of the simplest is the function =NBVAL which is used to count all nonblank cells in a data range. It accepts up to 255 arguments, ideal for a selection of several distant cells.

In our example, the function =NBVAL counts only cells in the "Participation" column that contain values, even formulas that return an empty result, while ignoring empty cells. Here it detects 6 cells which include values 鈥嬧媋nd displays the corresponding value.

We also note the functions =NB to calculate the number of cells containing a real as well as =NB.VIDE to count the number of empty cells.


2. The count provided by Excel

For simplicity, the Microsoft software offers a function to display the number of non-empty cells in the status bar located at the bottom of the window:
  • The user must select the desired cells, rows or columns by holding the key Ctrl depressed;
  • The number of cells with a value is displayed directly in the status bar;



However, if this result is not displayed, just right-click on the status bar and check the field Nb (names) ou Nb (non vides) selon the version of Excel.


add a comment of How to count non-blank cells in Excel?
Comment sent successfully! We will review it in the next few hours.