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 ?
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 ?
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
Originally Posted by judoist
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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>
Thanks guys...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks