# Excel

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!

1. 1
1. Try some of the following links:

http://search.yahoo.com/search?fr=mcafee&p=algorithm+that+will+give+the+sum+of+cubs

Sra

posted by SraJMcGin
2. 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

posted by John

## Similar Questions

1. ### math

The two of us ordered a pizza whose area was the same as the area of a square in which the sum of the squares of the four sides plus the sum of the squares of the two diagonals is 400. The pizza's area was A. 50 B. 100 C. 150 D.
2. ### Math!!

A square quilt for a child's bed has a border made up of 32 pieces with an area of x each, and 4 small squares with an area of 1 square inch each. The main part of the quilt is made of 64 squares with an area of x squared each. If
3. ### math

Area A sequence of smaller squares is formed by connecting the midpoints of the sides of a larger square. (a) If the area of the largest square is 1 square unit, determine the first five terms of a sequence that describes the area
4. ### math

Area A sequence of smaller squares is formed by connecting the midpoints of the sides of a larger square. (a) If the area of the largest square is 1 square unit, determine the first five terms of a sequence that describes the area
5. ### counting

how many squares are in an 8x8 checkerboard? (the answer is not 64 because that's too low.) Thank you for using the Jiskha Homework Help Forum. Unfortunately, you don't state the size of each square. Hopefully the following will
6. ### Algebra

Babylonian Problem - circa 1800 BC An area, A, consisting of the sum of two squares is 1000. The side of one square is 10 less than 2/3 of the side of the other square. What are the sides of the squares?
7. ### Algebra

Babylonian Problem - circa 1800 BC An area, A, consisting of the sum of two squares is 1000. The side of one square is 10 less than 2/3 of the side of the other square. What are the sides of the squares?
8. ### college math

I do not understand a problem from a text book or how to solve the problem for the answer. Could shomeone show me the steps (show work) on how to solve this question. The sum of the intergers from 1 through n is n(n+1)/2. the sum