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.

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Hey, wait!Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.