Let's see A1 for first integer, and B1 as last integer...
=SUM(ROW(INDIRECT("A"&INDIRECT("A1")&":B"&INDIRECT ("B1")))^2)

Hi. For this particular equation, another option might be:

=(A1*((3-2*A1)*A1-1)+B1*(B1+1)*(2*B1+1))/6

as the sum from 1 to n 'squared' is n*(1 + n)*((1 + 2*n)/6)
--
HTH. :)
Dana DeLouis
Windows XP, Office 2003


"Daniel Erwin" wrote in message
oups.com...

Or maybe if I have two cells, with the starting integer in A1 and the
ending integer in A2 the funciton would look as follows:
SUMFUCNC((A1:A2)^2). This would also return 1+4+9+...+100.

Let's see A1 for first integer, and B1 as last integer, use this array
formula:
=SUM(ROW(INDIRECT("A"&INDIRECT("A1")&":B"&INDIRECT ("B1")))^2)

Regards,
Daniel