COUNTBLANK Function in Excel with Example

COUNTBLANK ()

This function counts the number of blank cells in a range. 

Best view in desktop mode.

	A	B	C	D
1	Values		Count
2	50		1
3			=COUNTBLANK(A2:A10)
4	Andrew
5	20%
6	Simple
7	25.52
8	9-Mar-20
9	#DIV/0!
10	FALSE
11

Syntax

=COUNTBLANK(RangeToTest)

Formatting

No special formatting is needed.

Functions for Counting

Ø  To count only numbers, use COUNT()

Ø  To count numbers and text value, use COUNTA()

Ø  To count based on one criteria, use COUNTIF()

Ø  To count based on multiple criteria, COUNTIFS()

Ø  To count blank cells, use COUNTBLANK()

COUNTIFS in Excel

<<  Previous

Next  >>

TEXT In Excel