# SUMIF

## [data-colorid=y6e525vggr]{color:#5f5e5e} html[data-color-mode=dark] [data-colorid=y6e525vggr]{color:#a1a0a0}[data-colorid=bah42xic6i]{color:#5f5e5e} html[data-color-mode=dark] [data-colorid=bah42xic6i]{color:#a1a0a0}[data-colorid=w6d8113w1w]{color:#363636} html[data-color-mode=dark] [data-colorid=w6d8113w1w]{color:#c9c9c9}Definition

This function adds the cell using a given criteria.

## Syntax

• array- is the array of cells you want to apply the condition.

• condition - the condition used to determine which cells to add.
• subrange - optional, it is the array of cells to sum together.If 'subrange' argument is omitted then SUMIF treats 'array' as 'subrange'.

### Step 4: Excellentable will generate the outcome when hitting enter.

A
B
C
D
1
State
Revenue
 Population
Total area in mi2
Land area in mi2
Water area in mi2
House seat(s)
2
Alabama
2.4
4833722
52,420 (135,767)
3
242.2413
735132
665,384 (1,723,337)
4
Arizona
23.765
6626624
113,990 (295,233)
5
Arkansas
-56.58
2959373
53,179 (137,733)
6
California
-0.5
38332521
163,695 (423,968)
7
4
5268367
104,094 (269,602)
8
Connecticut
1
3596080
5,543 (14,356)
9
Delaware
3.14159
925749
2,489 (6,446)
10
Florida
-3.141
19552860
65,758 (170,312)
11
Georgia
-242.2413
9992167
59,425 (153,910)
12
Hawaii
3141.59
1404054
10,932 (28,314)
13
Idaho
0.5
1612136
83,569 (216,443)
14
15
3407.5963
E
F
G
1
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
103,642 (268,432)
452 (1,171)
7
8
4,842 (12,541)
701 (1,816)
5
9
1,949 (5,048)
540 (1,399)
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)
2
13
82,643 (214,044)
926 (2,398)
2
14
15

JavaScript errors detected