COUNTBLANK function - The function performs counting empty cells 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!
You should read it
- 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
- How to calculate and color blank cells in Excel
- COUNTIFS function - The function performs counting the number of cells in a data table that satisfy many conditions in Excel
- How to use the SUBTOTAL function in Excel
- DCOUNTA function, how to use the function to count non-empty cells in Excel
- COUNTBLANK function - Count the number of blank (empty) cells in a selected range or array in Excel
- Cell counting function with data in Excel - Enclose example
- Conditional counting function in Excel
- COUNTIF function - Function that counts the number of cells in a data table that meet certain conditions in Excel
- How to display function arguments in Excel
- How to use the SUM function to calculate totals in Excel
May be interested
COUNTIF function - Function that counts the number of cells in a data table that meet certain conditions in Excel
COUNTIFS function - The function performs counting the number of cells in a data table that satisfy many conditions in Excel
DEVSQ function - The function returns the sum of squares of deviations of data points from the sample mean in Excel
The EXPON.DIST function - The function returns the exponential distribution in Excel
F.DIST - The function returns the probability distribution F in Excel
F.DIST.RT function - The function returns the right probability distribution F for 2 data sets in Excel