Add specified amount of numbers in a list
 

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 ?


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

Add specified amount of numbers in a list
 

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

Add specified amount of numbers in a list
 

Another option

=SUM(OFFSET($A$1,(ROW(A1)-1)*20,0,20,1))

--

HTH

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


"Bryan Hessey"
wrote in message
news:Bryan.Hessey.1z1pvm_1132910701.3327@excelforu m-nospam.com...

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

Add specified amount of numbers in a list
 

Thanks guys...


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