posted by .

Like obtaining the sum of squares in an area in Excel


I would like an algorithm/module that will give me the sum of cubes.

Can anyone help me?

  • Excel -

    Try some of the following links:



  • Excel -

    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
    then insert ^3 (or any powers)
    =sum(B2:C2^3,E2:H2^3) and press CTRL+Shift+Enter. You should get 692

Respond to this Question

First Name

School Subject

Your Answer

Similar Questions

  1. Math

    Clara measured the diameter of the circle. How many centimeters is the diamter?
  2. Excel

    I have to create a payroll document for class using Excel and I am quite confused. Here is the parts that I am confused on. -I have to calculate the number of years the employees have been working for us, I believe the function I need …
  3. progra

    how would i be able to write a function module for average from this pseudo-code and then use it to write an algorithm. Sum integer Num integer Count integer Count:= 0 Sum:=0 Dowhile count <3 Println “Enter Num: ” Read Num Sum …
  4. Statistics - Excel

    Can anyone help me with finding Standard Deviation in Excel?
  5. Data Analysis Excel

    Why would you exchange information between Excel and some other applications?
  6. 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 of …
  7. Excel

    When I use the sum button it gives me the wrong answer but when I times it comes out right. How do I put the total in the total column?
  8. Excel

    I have my employee schedule in a excel sheet. It is a weekly schedule that doesn't change week by week, but changes day by day within a week. Every Monday, Tuesday, etc. is the same schedule. In the file are days for Monday, Tuesday, …
  9. Microsoft Excel

    The order of precedence is very important when building formulas in Excel. Which of the following formulas will produce 778 as the result?
  10. 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. 200

More Similar Questions