Kiến thức

# How to Use Excel COUNTBLANK Function in Office 365?

Bạn đang xem: How to Use Excel COUNTBLANK Function in Office 365?

## Excel COUNTBLANK Function:

In this article, you will learn how to use Excel COUNTBLANK Function in Office 365 with its syntax, explanation, and examples. Let’s step into this article!! Get an official version of MS Excel from the following link:

https://www.microsoft.com/en-in/microsoft-365/excel

• COUNTBLANK Function – Description

• Syntax

• Examples

• Closure

## COUNTBLANK Function – Description:

• This function returns the number of blank cells from the given input range and returns the output in number.

## Syntax:

=COUNTBLANK(range)

### Parameter Description:

Range – The range of cells from which you want to count the empty-cells.

### Note:

• It will not consider the cells that contains numbers, text, errors, etc.
• Formulas that return empty text (” “) is considered to be a blank cell and it will be counted.
• The cells that contain zero are considered as non-blank cells, so it will not be counted.

## Examples:

### Example 1:

• Refer to the below example image.
• You can see the inputs in five Columns that are A, B, C, D, and E, the result is listed in Column F.
• It counts only the blank cells.

### Example 2:

• The cells that contain zero are considered as non-blank cells, so it will not be counted.

## Closure:

In this article, you can grasp the usage of the Excel COUNTBLANK Function in Office 365 with its syntax, explanation, and examples. Leave your feedback in the below comment section. Thanks for visiting

Geek Excel.

Keep Learning!!

### Similar Function:

• COUNT Function

• COUNTA Function

• How to Use Excel “FACT Function” in Office 365? – {with Examples}

• How to Use Excel TRUNC Function in Office 365? – (with Examples)

Share on:

Chuyên mục: Kiến thức