COUNTBLANK function - Count the number of blank (empty) cells in a selected range or array in Excel

The previous article introduced you to the COUNT () function - a function that counts cells with numbers in the list of arguments. In this article, I will introduce one more counting function - COUNTBLANK (). This function will help you count empty cells in the selected range.

Description

The COUNTBLANK () function helps to count the number of blank (empty) cells in a selected range or array in Excel.

Syntax

= COUNTBLANK (range)

Inside:

- range: is the only and mandatory parameter of the function, range is the sequence of cells, an area to count the number of empty (empty) cells.

Note

- Cells containing formulas that return empty (empty) text will count like normal blank cells.

- Cells with value = 0 will not be counted.

For example

Count students without points (number of empty cells) in the following example:

COUNTBLANK function - Count the number of blank (empty) cells in a selected range or array in Excel Picture 2

In the data table with cell E3, the function returns an empty value.

Apply the formula COUNTBLANK (): = COUNTBLANK (E6: E13)

And the result is 3 because cell E3 is the formula but the result is empty.

COUNTBLANK function - Count the number of blank (empty) cells in a selected range or array in Excel Picture 3

This article described the syntax and usage of the COUNTBLANK () function. Hopefully, with the above simple example, you will understand how to use the COUNTBLANK () function in Excel. Good luck!

David Pac

Update 19 May 2020

You should read it

May be interested

Extremely simple instructions on how to fill in blank cells with 0 in Excel
when working in excel, you may encounter a situation where your spreadsheet has many blank cells and need to fill in values in those cells. don't worry, read the article below to learn how to fill in blank cells with 0 in excel.
COUNT function - Function that counts cells containing numbers in the list of arguments in Excel
count function: the function performs counting cells containing numbers in the list of arguments. syntax: count (value1, [value2], ...)
The COUNTIFS function, how to use the cell count function according to multiple events in Excel
the countifs function in excel to count cells satisfies many given conditions.
Instructions for deleting empty lines and columns in Excel 2016
sometimes your spreadsheet has too many blank lines and empty columns look very messy and lose aesthetics. to make the spreadsheet look better you can delete these blank lines and blank columns. however, instead of manually deleting each column, each blank line is very time-consuming, especially with long spreadsheets with many empty columns and empty lines.
Instructions to delete blank lines (blank lines) in Excel
the data in the excel document file that you are referencing has many blank cells and blank lines that cause the excel file to reverse the data position. you want to delete all the empty cells in that data file but if you delete each cell one by one, it will take a lot of time.
GEOMEAN function - The function returns the average of a positive array or range of data in Excel
geomean function: the function returns the average of a positive array or range of data. use the function to calculate the average growth when knowing the gross profit with variable interest rates. syntax: geomean (number1, [number2], ...)
How to count characters in Excel
to count characters in excel we need the help of the len function. the len function helps you count the number of characters including spaces in a given phrase. normally, the len function is not used alone, it will combine with other functions based on certain purposes.
DCOUNT function in Excel - Usage and practical examples
the dcounta function is one of many frequently used math functions in excel. the dcount function helps you count non-blank data cells in list columns or data arrays with defined conditions.
Count function in excel, formula, how to use count function in most detail
in excel, the count function is a powerful tool that helps you quickly count numeric values in a spreadsheet. whether you are new or familiar with excel, mastering the syntax and usage will make calculations easier. let's explore the details in the article below.
COUNTBLANK function - The function performs counting empty cells in the list of arguments in Excel
countblank function: the function performs counting empty cells in the list of arguments. syntax: countblank (range)