Calculate the number of empty cells and the number of non-empty cells in a specified area in Excel.

Source: Internet
Author: User

Calculate the number of empty cells and the number of non-empty cells in a specified area in Excel.

I. countblank

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.