Kiến thức

Count Blank/Nonblank Cells in Excel-Easy Excel Tutorial

Bạn đang xem: Count Blank/Nonblank Cells in Excel-Easy Excel Tutorial

Count Blank/Nonblank Cells

 

This example shows you how to count blank and nonblank cells in Excel.

1. The COUNTBLANK function below counts the number of blank cells in the range A1:A7.

COUNTBLANK function in Excel

2. The COUNTA function below counts the number of nonblank cells in the range A1:A7. COUNTA stands for count all.

COUNTA function in Excel

3. The COUNTIFS function below counts the number of blank cells in the range B1:B7 with one additional criteria (blue).

Count Blank Cells using COUNTIFS

Explanation: the COUNTIFS function (with the letter S at the end) in Excel counts cells based on two or more criteria. Use an empty string (two double quotes with nothing in between) to find blank cells.

4. The COUNTIFS function below counts the number of nonblank cells in the range B1:B7 with one additional criteria (pink).

Count Nonblank Cells using COUNTIFS

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