Kiến thức

How to Use Excel COUNTBLANK Function in Office 365?

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:

COUNTBLANK Function
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

Xem thêm: Bầu Đức tiếp tục mở rộng diện tích trồng chuối-VnExpress Kinh doanh

Jump To:

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

Xem thêm: Giới hạn hàm số dạng không trên không-0/0

Syntax:

=COUNTBLANK(range)

Parameter Description:

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

Sponsored Links

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.

Xem thêm: Cách chia sẻ máy in qua mạng Lan-Quantrimang.com

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.

"<yoastmark

Example 2:

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

"<yoastmark

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

See Also:

  • 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

Related Articles

Trả lời

Email của bạn sẽ không được hiển thị công khai. Các trường bắt buộc được đánh dấu *

Check Also
Close
Back to top button