Asked by John
Like obtaining the sum of squares in an area in Excel
=sumsq(a1:g1)
I would like an algorithm/module that will give me the sum of cubes.
Can anyone help me?
thankyouuuuuuuuuuu!
=sumsq(a1:g1)
I would like an algorithm/module that will give me the sum of cubes.
Can anyone help me?
thankyouuuuuuuuuuu!
Answers
Answered by
John
Someone sent this hint to me: It will work exactly as the excel function "sumsq()" on a continuous area and on a series of areas and with any power.
1)Say you have the A1 to H1 area below:
10 3 7 16 5 5 2 4
to obtain the sum of cubs write the following in a cell
=SUM(A2:H2^3) and then instead of pressing enter press CTRL + Shift + Enter. You should get 5788
2) If you want sums of powered areas within this area, say of B1:C1 and E1:H1 write
=sum(B2:C2,E2:H2)
then insert ^3 (or any powers)
=sum(B2:C2^3,E2:H2^3) and press CTRL+Shift+Enter. You should get 692
1)Say you have the A1 to H1 area below:
10 3 7 16 5 5 2 4
to obtain the sum of cubs write the following in a cell
=SUM(A2:H2^3) and then instead of pressing enter press CTRL + Shift + Enter. You should get 5788
2) If you want sums of powered areas within this area, say of B1:C1 and E1:H1 write
=sum(B2:C2,E2:H2)
then insert ^3 (or any powers)
=sum(B2:C2^3,E2:H2^3) and press CTRL+Shift+Enter. You should get 692
There are no AI answers yet. The ability to request AI answers is coming soon!
Submit Your Answer
We prioritize human answers over AI answers.
If you are human, and you can answer this question, please submit your answer.