Calculate the number of empty cells and the number of non-empty cells in a specified area in Excel.
I. countblank
Syntax:
Countblank (range)
Range is the area where the number of blank cells needs to be calculated.
Note: </P>
Even if the cell contains a formula that returns NULL text (""), the cell is also included, but the cell containing zero value is not included.
Ii. counta
Syntax: </P>
Counta (value1, value2 ,...)
Value1, value2,... represents the 1-30 arguments that you want to calculate. In this case, the value can be any data type, including blank text (""), but not blank
Number. If you do not need to calculate the logical value, text, or error value, you can use the count function.
Iii. Instances
The cell area to be counted. This parameter can be changed according to the problem requirements. For example, we need to count the number of empty cells in the entire column of column, we can use = countblank (A: a) in this way ).
Similarly, to count the number of non-empty cells in column B, use = counta (B: B ).
Iv. Knowledge Extension
How can I count non-empty cells and empty cells?
There are more questions about this. For example, if you want to count the number of students in the student scores, do you want to use these two functions?
In addition, these two functions can be used together with the count function to count the number of students in each subject, the number of students in each subject, and the number of students in each section.
Use the countif function to calculate the score segment.
Countif (range, criteria)
Range is the area of cells that need to calculate the number of cells that meet the conditions.
Criteria is a condition used to determine which cells will be calculated. The format can be a number, expression, or text.
For example, a condition can be expressed as 32, "32", "> 32", or "Apples ".
Note: Microsoft Excel provides other functions to analyze data based on conditions. For example, to calculate the sum of a numeric value based on a text string or a range, you can use the sumif worksheet function. To make the formula return one of two condition-based values, such as the sales bonus of a specified sales volume, you can use the if worksheet function.