posted by John

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?

  1. SraJMcGin

    Try some of the following links:



  2. 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
    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

Your Answer

Similar Questions

  1. Math

    the sum of the first n terms of an arithmetic series is -51. the series has a constant difference of -1.5 and a first term of four. Find the number of terms in the sum I find using an EXCEL spreadsheet is very helpful for these types …
  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. Excel

    The use of excel Excel is a very necessary tool for all businesses in today's job market. Excel makes it easy to organize, calculate, analyze and chart data. It can be used for both simple and concrete projects. Excels spreadsheets …
  5. Computer Applications

    An Excel workbook can contain more than one workshet. Give two examples of a spreadsheet application where it would be necessary to have more than one worksheet and explain your answer. Please help. I am lost when it comes to excel!!
  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. 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
  10. MATH

    if f (x) is a polynomial of degree 3 whose roots are p,q,r. FIND f (3) if sum of cubes of roots is 0 and sum of squares of roots and sum of roots are unit digit of 3^2018 and 5^50666666666 respectively?

More Similar Questions