On Mon, 8 May 2006 16:01:29 -0700, "Peo Sjoblom"
wrote:

One way where A1 holds n

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


Peo Sjoblom,

Thanks very much, it works fine, and now I'll just try figure out why
:)

Cheers,
Shankley
-
FunaxyrlRap-nocnglnubbqbgpbz