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.

__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.

The values are from A3 to A7.

##### STEP 4:

Press enter to get the results.

Return 2. There are 2 blank cells.

## Leave a Review