A small variation, array entered

=SUMSQ(ROW(INDIRECT("1:"&A1)))

"Peo Sjoblom" wrote:

One way where A1 holds n

=SUMPRODUCT(ROW(INDIRECT("1:" & A1))^2)


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"Shankley" wrote in message
...
Basically, I need to do a Sum of the Squares of the first 'n' Natural
Numbers. Something like:

function_name(n)

If 'n' is 8 say, then the function would return 204.

Thats 1*1 + 2*2 + 3*3 + 4*4 + 5*5 + 6*6 + 7*7 + 8*8

Likewise if 'n' is 6 say, then the function would return 91!

Or, if no funtion possible, is it possible to do the calculation with
conventional methods?

Thanks,
Shankley
-
FunaxyrlRap-nocnglnubbqbgpbz