Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How to Use the COUNTBLANK Function in Excel?

Date:2021-12-21 Author:Sandra

Have you ever used COUNTBLANK Function? Do you know how to use it. today’s tutorial is about COUNTBLANK Function.

You can use this function to get the total number of blank cells.

Formula:

=COUNTBLANK (range)

Range refers to the range of cells in which we want to count blank cells.

Let’s take an example. The range from cell A2 to cell A10 contains Number, Time, Date, and Text Formats.

Let’s guess what the final calculation for this range is.

How to Use the COUNTBLANK Function in Excel?

Well, it’s 2. Only cell A5 and cell A9 can be counted by COUNTBLANK.

How to Use the COUNTBLANK Function in Excel?

By the way, formulas that return empty text (“”) are considered blank and will be counted.

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *