COUNTBLANK Function in Excel

In this post, you’ll learn about COUNTBLANK Function its syntax and the way of using COUNTBLANK Function in excel spreadsheet.

What is COUNTBLANK Function?

The COUNTBLANK Function in excel is a statistical Function .COUNTBLANK Function will count the number of empty cell in a given range of cells. Ignore cells that contain text, number, and errors.

In financial analysis, this function will be useful in highlighting counting the empty cells.

Syntax

=COUNTBLANK(range)
Arguments:
  • = – built-in function.
  • COUNTBLANK() – function name.
  • range – specifies the range of cells.

Note:

  • Ignores any cells that contain text, number, errors and even zeros.
  • Arguments can be formulas that return empty text(“”) are considered as blank cells.

How to use COUNTBLANK Function in Excel?

COUNTBLANK Function is used to count only the empty cells.

Example:

Step 1:

Open the workbook in your Microsoft Excel.

Step 2:

Enter the data, in the workbook.

How to use COUNTBLANK Function in Excel?
STEP 3:

In the new cell, give the formula or the syntax. Start with ‘ =’ for every functions, COUNTBLANK to initiate functions name, followed by open parenthesis.

How to use COUNTBLANK Function in Excel?

The values are from A3 to A7.

STEP 4:

Press enter to get the results.

How to use COUNTBLANK Function in Excel?

Return 2. There are 2 blank cells.

Leave A Reply

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

You May Also Like

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
  • Excel
  • November 23, 2021