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.

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	State	Population	Total area in mi2	Land area in mi2
2	Alabama	4833722
3	Alaska	735132
4	Arizona	6626624
5	Arkansas	2959373
6	California	38332521
7	Colorado	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)

52,420 (135,767)

50,645 (131,170)

1,775 (4,597)

665,384 (1,723,337)

570,641 (1,477,950)

94,743 (245,383)

113,990 (295,233)

113,594 (294,207)

396 (1,026)

53,179 (137,733)

52,035 (134,770)

1,143 (2,960)

163,695 (423,968)

155,779 (403,466)

7,916 (20,502)

104,094 (269,602)

103,642 (268,432)

452 (1,171)

5,543 (14,356)

4,842 (12,541)

701 (1,816)

2,489 (6,446)

1,949 (5,048)

540 (1,399)

65,758 (170,312)

53,625 (138,888)

12,133 (31,424)

59,425 (153,910)

57,513 (148,958)

1,912 (4,950)

10,932 (28,314)

6,423 (16,635)

4,509 (11,678)

83,569 (216,443)

82,643 (214,044)

926 (2,398)

7

1

9

4

53

7

5

1

27

14

2

2