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
|
|||
2
|
|||
3
|
|||
4
|
|||
5
|
|||
6
|
|||
7
|
|||
8
|
|||
9
|
|||
10
|
|||
11
|
|||
12
|
|||
13
|
|||
14
|
|||
15
|
D
|
E
|
F
|
|
|---|---|---|---|
1
|
House seat(s)
2
50,645 (131,170)
1,775 (4,597)
7
3
570,641 (1,477,950)
94,743 (245,383)
1
4
113,594 (294,207)
396 (1,026)
9
5
52,035 (134,770)
1,143 (2,960)
4
6
155,779 (403,466)
7,916 (20,502)
53
7
452 (1,171)
7
8
4,842 (12,541)
701 (1,816)
5
9
1,949 (5,048)
1
10
53,625 (138,888)
12,133 (31,424)
27
11
57,513 (148,958)
1,912 (4,950)
14
12
6,423 (16,635)
4,509 (11,678)
13
82,643 (214,044)
926 (2,398)
2
14
15
COUNTBLANK(A2:F13):
5