Skip to main content

SUMSQ

Definition: 

Returns the sum of the squares of a series of numbers and/or cells.

Sample Usage:

SUMSQ(A2:A100)

 SUMSQ(1,2,3,4,5)

 SUMSQ(1,2,A2:A50)

Syntax:

SUMSQ(value1, [value2, ...])

value1 - The first number or range whose squares to add together.

value2, ... - [ OPTIONAL ] - Additional numbers or ranges whose squares to add to the square(s) of value1.

Notes:

If only a single number for value1 is supplied,SUMSQ returns value1 squared.

Although SUMSQ is specified as taking a maximum of 30 arguments, Google Sheets supports an arbitrary number of arguments for this function.

To use the SUMSQ Formula, simply begin with your edited Excellentable:

Then begin typing the SUMSQ formula in the area you would like to display the outcome: 

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
15
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
15
SUMSQ:
74

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.