# 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 against criterion1.
• criterion1 - The pattern or test to apply to criteria_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.

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`.

### 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
State
 Population
Total area in mi2
Land area in mi2
2
Alabama
4833722
3
735132
4
Arizona
6626624
5
Arkansas
2959373
6
California
38332521
7
5268367
8
Connecticut
3596080
9
Delaware
925749
10
Florida
19552860
11
Georgia
9992167
12
Hawaii
1404054
13
Idaho
1612136
14
15
COUNTIFS(A2:A13, "A*", A2:A13, "*A"):
3
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

JavaScript errors detected