summing to the sixth power without creating a new column

English
#1

I would like to sum the 6th powers of real numbers in cells A:1 to A:8 without creating an auxiliary column.
Please explain your shortcuts, if any.

#2

Apparently this is not a question for the mathematical formula editor but for the spreadsheet application. Please retag to replace math with calc.

#3

something like =SUM((A1:A8)^8) enter with strg shift enter

#4

=SUMPRODUCT((A1:A8)^6) should do without using an explicit array formula

#5

@karolus, If all cells has 1 your formula gives 262144, and not 8 (1^6*8).

#6

@LeroyG

Formula of @karolus correctly yields 8 for me (though it use power of 8 instead of 6 as per question)

image description

#7

@anon73440385

My error. Thanks for letting me know. I typed {=SUM(A1:A8)^6}, without the extra parentheses.

If you think it is fine, you can delete my comments so as not to generate confusion. Thanks.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.