summation question

[braun247]

I would like to find the sum of the squared integers from 1 to a 10000.

How can I do that without have to enter in 1 to 10000 in a cell and then creating a really long formula?

Thanks

JD

 

[shg]

Try this:

      A ---B--- -------C-------- ----------D-----------
  1   n 10,000  333,383,335,000  C1: =n*(n+1)*(2*n+1)/6

 

[braun247]

How do I enter that in excel? I understand that column and rows, but nothing in the formula says to use the other cells.

Thanks for your help.

JD

 

[shg]

n is a named range that refers to B1. You can change n in the formula to B1.

 

[Dave Patton]

an alternative

=SUMPRODUCT(ROW(INDIRECT("1:10000"))^2)