Today in this article I
will discuss about the excel function COUNTBLANK, a very small inbuilt function
in Microsoft Excel.
In
the last article, we discussed about How to Count Not Blank Cells in Excel.
In
this article, we will learn How to Count Blank Cells, in some compound formula
it becomes necessary to learn these small functions to simplify the existing
excel formula.
Let
us first discuss about COUNTBLANK then we will discuss where can we use it and
how we can implement this function.
Description
As
the name suggest the Microsoft Excel COUNTBLANK function counts the number of
cells that are empty.
Note : As COUNTBLANK count the cells
that are blank, if any space is present in any cell it will not be counted
because space is also a character and space ‘alone’ is not visible to bare
eyes. Therefore, it is better to use TRIM function while using COUNTBLANK
Function if you are not sure that all visible empty cells are not containing
any ‘space’.
Syntax
The
syntax for the COUNTBLANK function in Microsoft Excel is:
=COUNTBLANK(range)
Parameters or Arguments
range
The
range of cells to count empty cells.
Returns
The
COUNTBLANK function returns a numeric value.
How to use COUNTBLANK Function in Excel ?
1.
Select a cell, then
2.
Type ‘=’ sign in
that cell or in the formula bar
3.
Type ‘COUNTBLANK(‘ or type COU, a drop down
list will appear, select COUNTBLANK, press TAB button
4.
Select the range
or alternatively you can type the range as we do in the basic SUM function. Hit
enter.
5.
Done.
 |
| How to use COUNTBLANK function to count Blank cells in Excel |
 |
| How to use COUNTBLANK & COUNTA function to count Blank and Not Blank cells in Excel |
We
can use COUNTBLANK nested with other functions like INDEX or SUMPRODUCT, we
will discuss it in another article in details with examples.
I hope this article is informative & you enjoyed this
article.
Thank you for reading…
No comments:
Post a Comment