| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find same numbers in a list in Excel | Excel Discussion (Misc queries) | |||
| How do I add an area code to a list of phone numbers in Excel? | Excel Worksheet Functions | |||
| How do I create a list of sequential numbers using Excel or Acces. | Excel Discussion (Misc queries) | |||
| If I create a random list in Excel, does it repeat numbers? | Excel Worksheet Functions | |||
| check numbers in a list | Excel Discussion (Misc queries) | |||
Linear Mode
