In you first output cell enter

=SUMPRODUCT(--(ROW($A$1:$A$1000)(ROW(A1)-1)*10),--(ROW($A$1:$A$1000)<=ROW(A
1)*10),$A$1:$A$1000)

and copy down until you run out

--

HTH

RP
(remove nothere from the email address if mailing direct)


"EFFY" wrote in message
...
I've a 1000 number entries (i.e n = 1000). I want to sum then in tens,
that
is, 1-10, 2-11, 3-12,...990-1000). I want to do this using excel macro.
Please will somebody write the code for me?