Counts the number of blank cells in the specified cell range.
Syntax
COUNTBLANK(range)
Range is the range in which the number of blank cells needs to be calculated.
Description
Even if the cell contains a formula that returns empty text (""), the cell will be counted, but cells containing zero values Not counted.
At work, Sometimes it is necessary to enter large amounts of datain forms.
While working hard, the leader suddenly asked how much data had not been recorded and was still there Count emptywhite cells one by one?
Time-consuming and error-prone, only one function can solve this trouble.
This involves the COUNTBLANK function, which can help us quickly count the number of blank cells in the data table.
Next, take this table as an example to explain the specific steps.
￭ Select cell B2, click Insert Function, find and select the COUNTBLANK function in the search box, and click OK.
￭ Here, we need to fill in the value of "area".
Select A2 to A34 to fill in, click OK, and you will immediately know how much data has not been entered.
This function is simple and easy to use, have you learned it~
支付宝扫一扫 
评论列表（196条）
测试