HOW TO COUNT BLANK CELLS USING COUNTBLANK FUNCTION IN GOOGLE SHEETS?

Table of Contents

INTRODUCTION

COUNTBLANK FUNCTION comes under the STATISTICAL FUNCTIONS category in GOOGLE SHEETS.

The other difference is that it works independently of the type of data which means that it would work for numbers as well as text or any other data type.

COUNTBLANK FUNCTION is very helpful when we need to use any nested functions to make a check on the number of cells containing the number or number type of data.

This function is one of those functions which are helpful.

Let us learn ,how to use COUNTBLANK function in GOOGLE SHEETS.

PURPOSE OF COUNTBLANK FUNCTION IN GOOGLE SHEETS

COUNTBLANK FUNCTION returns the total number of blank cells from a given data set or range .

COUNTBLANK FUNCTION is apt for the situation when we want to count the number of cell which does’nt contain any value i.e. if they are blank or empty.

For example, suppose we have a large number of cells containing different words including some empty or blank cells. We can find out the number of total blank or empty cells within a second from the given row, column, table or any range by using COUNTBLANK function.

This function is a must to learn because we encounter such situations frequently while using GOOGLE SHEETS.

PREREQUISITES TO LEARN COUNTBLANK FUNCTION

No specific prerequisite but to know how to use the function in GOOGLE SHEETS.


WHAT IS THE SYNTAX OF COUNTBLANK FUNCTION?

The Syntax [ the way the function is used ] for the function is

=COUNTBLANK(ARRAY OR RANGE OR TABLE)

ARRAY or RANGE or TABLE is the reference where you want to search for the blank cells.

EXAMPLE:COUNTBLANK FUNCTION IN GOOGLE SHEETS

Let us take an example to learn the use of COUNTBLANK function in GOOGLE SHEETS.

Let us take random numbers with a few blank cells.

SAMPLE DATA FOR THE EXAMPLE

The picture above shows a random data just for the demonstration of COUNTBLANK FUNCTION.



FOLLOW THE STEPS TO FIND OUT THE BLANK CELLS USING COUNTBLANK FUNCTION

  • Select the cell where you want the result.
  • Enter the formula as =COUNTBLANK(RANGE).
  • For our example, we’ll use the formula as =COUNTBLANK(H3:AX23).
  • Press ENTER.
  • The result will appear.
  • The following picture shows the result and usage.
RESULT

The result appears as 28. Try counting the blank cells.

So, in this way , we can find out the number of blank cells within seconds.