COUNTBLANK

Definition of COUNTBLANK

Returns the number of empty cells in a given range.

Sample Usage

COUNTBLANK(A2:C100)

Syntax

COUNTBLANK(range)

• range - The range in which to count the number of blanks.

See Also

DCOUNTA: Counts values, including text, selected from a database table-like array or range using a SQL-like query.

DCOUNT: Counts numeric values selected from a database table-like array or range using a SQL-like query.

COUNTUNIQUE: Counts the number of unique values in a list of specified values and ranges.

COUNTIF: Returns a conditional count across a range.

COUNTA: Returns a count of the number of values in a dataset.

COUNT: Returns a count of the number of numeric values in a dataset.

To use the COUNTBLANK Formula, simply begin with your edited Excellentable:

Then begin typing the COUNTBLANK formula in the area you would like to display the outcome: 

By selecting the cell range you would like to calculate the COUNTBLANK formula, Excellentable generates the outcome:

	A	B	C
1	State	Population	Total area in mi2	Land area in mi2	Water area in mi2
2	Alabama	4833722	52,420 (135,767)
3	Alaska		665,384 (1,723,337)
4	Arizona	6626624	113,990 (295,233)
5	Arkansas	2959373
6	California	38332521	163,695 (423,968)
7	Colorado	5268367	104,094 (269,602)
8	Connecticut	3596080	5,543 (14,356)
9	Delaware	925749	2,489 (6,446)
10	Florida	19552860	65,758 (170,312)
11	Georgia	9992167	59,425 (153,910)
12	Hawaii	1404054	10,932 (28,314)
13	Idaho	1612136	83,569 (216,443)
14
15

	D	E	F
1

House seat(s)

50,645 (131,170)

1,775 (4,597)

7

570,641 (1,477,950)

94,743 (245,383)

1

113,594 (294,207)

396 (1,026)

9

52,035 (134,770)

1,143 (2,960)

4

155,779 (403,466)

7,916 (20,502)

53

452 (1,171)

7

4,842 (12,541)

701 (1,816)

5

1,949 (5,048)

1

53,625 (138,888)

12,133 (31,424)

27

57,513 (148,958)

1,912 (4,950)

14

6,423 (16,635)

4,509 (11,678)

82,643 (214,044)

926 (2,398)

2

COUNTBLANK(A2:F13):