In excel how to get the count of blank cells?

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Next Question:
In Excel how to count NON-BLANK cells having ONLY Non-numeric values in a range?
Posted by:
Ahmed Aziz
22-March-2014

To count the number of cells which are blank.

Microsoft Excel

Question added by Pravin Muthuswamy , Project Engineer , Brigade Enterprises Ltd
Date Posted: 2014/03/21

Upvote (1) Views (6) Followers (2) Answers (4) Report Question

Write an Answer
Register now or log in to answer.

4 Answers

by AHRAR ALI KHAN , Sales Executive , Al Manwari Trading LLC

Just follow the below steps:

* Press the button " = "

* Type "COUNTBLANK"

* Press TAB key.

* Select the range / table in which you are counting the blank cells.

* Press "CTRL + ENTER"

Hopefully, This will give you the desired results.

Downvote Reply () Report

by Ahmed Aziz , Software Development & Testing , Innernet, Inc.

=countblank(range)

i.e

=countblank(A1:A10)

Downvote Reply () Report

kennith lacbayen

by kennith lacbayen , Mechanical Technician , Hyundai

least count for vernier = 0.1mm least count for micrometer = 0.01mm

Downvote Reply () Report

by Divyesh Patel , Assistant Professional Officer- Treasury , City Of Cape Town

=COUNTBLANK(X1:X11)

Downvote Reply () Report

Popular Searches

Sales Executive Jobs Engineers Jobs Engineering Technicians Jobs Accountant Jobs Driver Jobs

Write Your Answer

More Questions Like This

Microsoft Excel - How can you fill blank cell under column - Country in below table without manually adding in each cells, like UAE has?
Top Answer: by using auto fill or copy and select then press enter or use both formulas IF and ISBLANK ... See More

Answers (26)
In Excel when we enter numbers, the value appears as # in cells Whats the keyboard shortcut to resolve this matter other than mouse?
Top Answer: <p><strong>ALT + H + O + I - Excel2007</strong></p> <p><strong>ALT + ... See More

Answers (4)
In excel, how to calculate number of symbols in one cell?
Top Answer: Select the cell where you want to see the numbers of symbols and =LEN (D5) press enter See More

Answers (1)
What command do we use to count the total number of lines, words, and characters contained in a file?
Top Answer: <p>wc - print newline, word, and byte counts for each file</p> <p>Examples:</p> & ... See More

Answers (5)

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.