ROW

Definition of ROW:

Returns the row number of a specified cell.

Sample Usage

ROW(A9)

Syntax

ROW([cell_reference])

cell_reference - [ OPTIONAL - The cell in which the formula is entered by default ] - The cell whose row number will be returned.
- if cell_reference is a range more than one cell wide and the formula is not used as an array formula, only the numeric value of the first row in cell_reference is returned.

Step 1. To use the ROW Formula, start with the Excellentable you would like to edit.

Step 2. Then type the ROW formula into the cell you have chosen to display the outcome:

Step 3. Fill in the value.

By adding the values you would like to calculate, Excellentable generates the outcome:

A

B

C

D

1

State

Population

Total area in mi2

Land area in mi2

Water area in mi2

House seat(s)

2

Alabama

4833722

52,420 (135,767)

50,645 (131,170)

3

Alaska

735132

665,384 (1,723,337)

570,641 (1,477,950)

4

Arizona

6626624

113,990 (295,233)

113,594 (294,207)

5

Arkansas

2959373

53,179 (137,733)

52,035 (134,770)

6

California

38332521

163,695 (423,968)

155,779 (403,466)

7

Colorado

5268367

104,094 (269,602)

103,642 (268,432)

8

Connecticut

3596080

5,543 (14,356)

4,842 (12,541)

9

Delaware

925749

2,489 (6,446)

1,949 (5,048)

10

Florida

19552860

65,758 (170,312)

53,625 (138,888)

11

Georgia

9992167

59,425 (153,910)

57,513 (148,958)

12

Hawaii

1404054

10,932 (28,314)

6,423 (16,635)

13

Idaho

1612136

83,569 (216,443)

82,643 (214,044)

14

	E	F
1

2

1,775 (4,597)

7

3

94,743 (245,383)

1

4

396 (1,026)

9

5

1,143 (2,960)

4

6

7,916 (20,502)

53

7

452 (1,171)

7

8

701 (1,816)

5

9

540 (1,399)

1

10

12,133 (31,424)

27

11

1,912 (4,950)

14

12

4,509 (11,678)

2

13

926 (2,398)

2

14

6