COUNTIFS
Definition of COUNTIFS
Returns the count of a range depending on multiple criteria.
Sample Usage
COUNTIFS(A1:A10, ">20", B1:B10, "<30")
COUNTIFS(A7:A24, ">6", B7:B24, "<"&DATE(1969,7,20))
COUNTIFS(B8:B27, ">" & B12, C8:C27, "<" & C13, D8:D27, “<>10�)
Syntax
COUNTIFS(criteria_range1, criterion1, [criteria_range2, criterion2, ...])
criteria_range1- The range to check againstcriterion1.criterion1- The pattern or test to apply tocriteria_range1.criteria_range2, criterion2...- [ OPTIONAL ] - Additional ranges and criteria to check; repeatable.
Notes
- Any additional ranges must contain the same number of rows and columns as
criteria_range1.
See Also
COUNTIF: Returns a conditional count across a range.
COUNT: Returns a count of the number of numeric values in a dataset.
SUMIFS: Returns the sum of a range depending on multiple criteria.
AVERAGEIFS: Returns the average of a range depending on multiple criteria.
IF: Returns one value if a logical expression is `TRUE` and another if it is `FALSE`.
To use the COUNTIFS Formula, simply begin with your edited Excellentable:
Then begin typing the COUNTIFS formula in the area you would like to display the outcome:
By selecting the multiple ranges of cells and entering the multiple criteria you want to meet across all selected ranges for COUNTIFS formula, Excellentable generates the outcome:
A
|
B
|
|
|---|---|---|
1
|
||
2
|
||
3
|
||
4
|
||
5
|
||
6
|
||
7
|
||
8
|
||
9
|
||
10
|
||
11
|
||
12
|
||
13
|
||
14
|
||
15
|
C
|
D
|
E
|
|
|---|---|---|---|
1
|
Water area in mi2
House seat(s)
2
52,420 (135,767)
50,645 (131,170)
1,775 (4,597)
3
665,384 (1,723,337)
570,641 (1,477,950)
94,743 (245,383)
4
113,990 (295,233)
113,594 (294,207)
396 (1,026)
5
53,179 (137,733)
52,035 (134,770)
1,143 (2,960)
6
163,695 (423,968)
155,779 (403,466)
7,916 (20,502)
7
104,094 (269,602)
103,642 (268,432)
452 (1,171)
8
5,543 (14,356)
4,842 (12,541)
701 (1,816)
9
2,489 (6,446)
1,949 (5,048)
540 (1,399)
10
65,758 (170,312)
53,625 (138,888)
12,133 (31,424)
11
59,425 (153,910)
57,513 (148,958)
1,912 (4,950)
12
10,932 (28,314)
6,423 (16,635)
4,509 (11,678)
13
83,569 (216,443)
82,643 (214,044)
926 (2,398)
14
15
F
|
|
|---|---|
1
|
2
7
3
1
4
9
5
4
6
53
7
7
8
5
9
1
10
27
11
14
12
2
13
2
14
15