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
asked by John
  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

Respond to this Question

First Name

Your Response

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
  9. math quadratic functions

    Alice cuts a ribbon of length 40cm into two pieces to form two squares as shown in th figure (there was no figure, but from my assumption the two squares are probably different ). Let xcm be the length of a side of one of the two
  10. Algebra

    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?

More Similar Questions