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)
COUNTIFS function - The function performs counting the number of cells in a data table that satisfy many conditions in Excel
countifs function: the function performs counting the number of cells in a data table that satisfy many conditions. syntax: countifs (criteria_range1, criteria1, [criteria_range2, criteria2], ...)
DEVSQ function - The function returns the sum of squares of deviations of data points from the sample mean in Excel
devsq function: returns the sum of squares of deviations of data points from the sample mean. syntax: devsq (number1, [number2], ...)
The EXPON.DIST function - The function returns the exponential distribution in Excel
expon.dist function: the function returns the exponential distribution, using this function to model the time of events. syntax: expon.dist (x, lambda, cumulative)
F.DIST - The function returns the probability distribution F in Excel
f.dist function: the function returns the probability distribution f. the function supports the version from excel 2010. syntax: f.dist (x, deg_freedom1, deg_freedom2, cumulative)
F.DIST.RT function - The function returns the right probability distribution F for 2 data sets in Excel
f.dist.rt function: the function returns the right probability distribution f for 2 data sets. support functions from the excel 2010 version. syntax: f.dist (x, deg_freedom1, deg_freedom2)

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

You should read it

May be interested

Office information