In excel how to get the count of blank cells?

Question

To count the number of cells which are blank.

AHRAR ALI KHAN · Answer

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.

Ahmed Aziz · Answer

=countblank(range)

i.e

=countblank(A1:A10)

kennith lacbayen · Answer

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

Divyesh Patel · Answer

=COUNTBLANK(X1:X11)