The Excel COUNTBLANK function is used to count the number of empty cells in an area, an array is preselected efficiently.
The syntax and usage of the COUNTBLANK function in Excel is very simple, but it has great applications in calculations and statistics. But not everyone understands the meaning and how to use this function, the following software article will guide you how to use the COUNTBLANK function.
INSTRUCTIONS FOR USING THE COUNTBLANK FUNCTION IN EXCEL – ILLUSTRATIVE EXAMPLE
Syntax: COUNTBLANK(Range)
Where:
Range: The array is selected to count the number of empty cells in it.
Note: Zero is not blank.
Illustrative example: Give a list of a group of students who achieved and did not achieve scholarships.
Students who do not pass the scholarship denote empty cells. Count the number of non-scholarship students in that group.
The formula in cell B11 is: =COUNTBLANK(C5:C9)
We have the result:
With this function, you can count the number of students who did not win scholarships very simply, right? How to use the COUNTBLANK function in excel to count the total number of empty cells on a preselected area. Therefore, this function is commonly used in the process of calculation and statistics.
https://thuthuat.taimienphi.vn/ham-countblank-trong-excel-952n.aspx
STANDARDIZE function, DATEDIF function is also a function in Excel that supports in work a lot. To use