COUNTBLANK function - The function performs counting empty cells in the list of arguments in Excel

COUNTA function - The function performs counting non-blank cells in the list of arguments in Excel
COUNT function - Function that counts cells containing numbers in the list of arguments in Excel

The following article introduces you to the COUNTBLANK function - one of the functions in the group of statistical functions that is very popular in Excel.

COUNTBLANK function - The function performs counting empty cells in the list of arguments in Excel Picture 1

Description: The function performs counting empty cells in the list of arguments.

Syntax: COUNTBLANK (range)

Inside:

- range: Range to count empty cells.

Attention:

- The function performs counting empty cells, cells with a value of 0 are not counted.

For example:

Count the number of blanks in the table below:

COUNTBLANK function - The function performs counting empty cells in the list of arguments in Excel Picture 2

- In the cell to calculate, enter the formula : = COUNTBLANK (B6: D10)

COUNTBLANK function - The function performs counting empty cells in the list of arguments in Excel Picture 3

- Press Enter -> number of blank cells in the data table is:

COUNTBLANK function - The function performs counting empty cells in the list of arguments in Excel Picture 4

- Where the cell value is 0 -> the function ignores not counting:

COUNTBLANK function - The function performs counting empty cells in the list of arguments in Excel Picture 5

Above are instructions and some specific examples when using the COUNTBLANK function in Excel.

Good luck!

Kareem Winters

Update 19 May 2020

You should read it

May be interested

COUNTIF function - Function that counts the number of cells in a data table that meet certain conditions in Excel
countif function: the function performs counting the number of cells in the data table that meet certain conditions. syntax: countif (range, criteria)
How to display function arguments in Excel
you often use functions in excel to calculate but there are many less used functions, so you do not remember the argument in the function. you do not need to worry because excel supports the function's display of arguments so that you can use the function as quickly as possible.
How to use the COUNT function in Excel
the count function in excel is the basic counting function that is often used to count how many cells are in an area or in the entire spreadsheet.
The COUNTA function, how to use the function to count cells containing data in Excel
the counta function in excel counts the number of cells containing data, non-empty cells in excel.
Delete empty data cells in Excel 2007 or 2010
in the following article, we will show you some basic actions to delete empty cells in excel 2007 or 2010 spreadsheet. first, open the spreadsheet and press ctrl + a to select all, or select certain data to apply ...
How to Create a List in Cells in Excel
if you want to know how to create a list of multiple lines in a cell on microsoft excel, read this article! whether it's creating a bulleted list with line breaks, a numbered list, or a drop-down list, it's easy once you know where the options are. today's tipsmake will show you three useful ways to insert any kind of list into cells in excel.
VAR function - The function of estimating variance based on a sample in Excel
var function: the function performs an estimate of the latter based on a sample from a given set. function arguments can be numbers, names or arrays, or references containing numbers.
Excel counting functions: Count and Countif
the regular processing of data calculations with excel spreadsheets, there will be a lot when you need to use the counting function. count and countif are the 2 most basic counting functions, easy to use but for those who are new to excel, you may not know how to use it.
How to use COUNTIF function on Excel
the countif function on excel is the cell count function to satisfy the given condition, often used in statistics tables.
How to use the SUM function to calculate totals in Excel
sum is a popular and very useful excel function, and is also a basic arithmetic function. as its name suggests, the sum function is used to calculate totals in excel. and the parameters can be single parameters or ranges of cells. in this article, tipsmake.com will guide you to use the sum function to calculate the sum in excel, the common errors when calculating sum by sum and how to fix it.

COUNTBLANK function - The function performs counting empty cells in the list of arguments in Excel

You should read it

May be interested

Office information