Hi,

Try

=SUM(INDIRECT("a"&(ROW()-1)*20+1&":A"&ROW()*20))

and formula-drag that down for 1/20th of the number of rows involved


judoist Wrote:
I have a long list of numbers in column A. I'd like to be able to add
these numbers, 20 at a time... i.e. numbers 1 -20, 21 -40, 41- 60,
etc.

Any ideas ?


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=488098