Looking for a SUMSQ( function, but with exponent.

[bbrother]

I know there must be an easy answer to this, but I can't think of it!

I have a column of cells containing integer numbers. I want to consider each number as if it were an exponent of 2, so I want the sum of all the cells in the column like sum(2^(A1:A22)).

For example: I have the numbers 1, 1, 2, 3 arranged in a column. I want a formula to calculate the sum of 2^1 + 2^1 + 2^2 + 2^3.

I suppose I could add another column with an intermediate calculation and just sum that up, but I was hoping there was an elegant solution.

 

[Dave Patton]

T202008a.xlsm
	A	B	C
1	1	1
2	2	4
3	3	9
4	4	16
5	5	25
6		55	55
7
1a

Cell Formulas
Range	Formula
B1:B5	B1	=A1^2
B6	B6	=SUM(B1:B5)
C6	C6	=SUMPRODUCT(A1:A5^2)

 

[bbrother]

Close, but that's the sum of the squares instead of the sum of the powers of 2. In your table above the formula in cell B1 should be =2^A1 instead of A1^2.

The sum of 2^1+2^2 + 2^3+2^4+2^5 = 62

I didn't know you could add operators to ranges - I think SUMPRODUCT(2^A1:A5) might do the trick.

 

[Dave Patton]

T202008a.xlsm
	A	B	C	D	E
1	1	1
2	2	4
3	3	9
4	4	16
5	5	25
6		55	55	62	62
1a

Cell Formulas
Range	Formula
B1:B5	B1	=A1^2
B6	B6	=SUM(B1:B5)
C6	C6	=SUMPRODUCT(A1:A5^2)
D6	D6	=SUMPRODUCT(2^(A1:A5))
E6	E6	=SUMPRODUCT(2^({1;2;3;4;5}))

 

[Rick Rothstein]

Assuming your numbers are in cells A1:A4...

=SUMPRODUCT(2^(A1:A4))