Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print
Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print

COUNTBLANK

Count cells that are blank in Excel
Counts the number of blank cells in the argument range

Rational

Count only blank cells

Description

The Excel COUNTBLANK function returns the count of blank cells within the reference arguments ignoring number and text cells.
For example, if A1:A10 contains three empty cells and remaining are filled with any value, to count blanks in the range A1:A10; =COUNTBLANK(A1:A10) will return 3 (ignoring any value in reference).

Syntax

=COUNTBLANK(range)

Parameters

range – Reference to count the blank cells.

Return Value

An Integer indicating counts of blank cells.

Key Notes

The COUNTBLANK function counts only blank cells in given range (value)
A cell with any value including zero or space is not counted.

Keep Reading Similar Functions:

Counts cells that are not blank in Excel

COUNTA

The COUNTA function count of numbers and text within the reference list of arguments ignoring blank cells, =COUNTA(A1:A10) will return 7 (disregard blank).

Read More »
Counts cells with only Numbers in Excel

COUNT

The COUNT function count of numbers within the reference list of arguments ignoring text & blank cells, =COUNT(A1:A10) will return 5 (only numeric).

Read More »
Find the average of numbers in Excel

AVERAGE

The AVERAGE function returns an average of numbers positioned in one or multiple ranges, =AVERAGE(5,15,30) add numbers and divide by 3, and returns 16.67.

Read More »
Count reference cells based on criteria in Excel

COUNTIF

The COUNTIF function returns a count of number based on given criteria like =COUNTIF(A1:A5,”>5″) that count numbers in the list >5 and returns 3.

Read More »
Count reference cells based on multiple criteria in Excel

COUNTIFS

The COUNTIFS function returns a count of numbers based on one or multiple given criterion based on dates, numbers, and text.

Read More »