Add n numbers in a column

[deilert]

I'm sure this is super basic for you guys.

Given a number n, I want to add up n numbers in a column.

Column of numbers
5
10
15
20

Example
If n=1 then 5 is returned
If n=2 then 15 is returned
If n=3 then 30 is returned
If n=4 then 50 is returned

I've tried to use a sum(index) based method without success.

Any ideas?

 

[Jonmo1]

Welcome to the board

Try

=SUM(A1:INDEX(A:A,n))

Hope that helps...

 

[VoG]

Try using INDIRECT

<b>Sheet9</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:64px;" /><col style="width:64px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="text-align:right; ">5</td><td style="text-align:right; ">3</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="text-align:right; ">10</td><td style="text-align:right; ">30</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="text-align:right; ">15</td><td > </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="text-align:right; ">20</td><td > </td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b>Spreadsheet Formulas</b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >B2</td><td >=SUM(INDIRECT<span style=' color:008000; '>("A1:A"&B1)</span>)</td></tr></table></td></tr></table> <br />Excel tables to the web - Excel Jeanie Html 4

 

[c_m]

I'm sure this is super basic for you guys.

Given a number n, I want to add up n numbers in a column.

Column of numbers
5
10
15
20

Example
If n=1 then 5 is returned
If n=2 then 15 is returned
If n=3 then 30 is returned
If n=4 then 50 is returned

I've tried to use a sum(index) based method without success.

Any ideas?

or
if your column of numbers is in incremental fashion in step 5,
try this in D2: =0.5*(5+D1*5)*D1
where D1 = total # of numbers you want to sum (n in your case)

 

[Aladin Akyurek]

Try...

=SUM(OFFSET($A$1,0,0,$D$1))

where D1 indicates the number of figures to sum starting to count from the first data cell on.

 

[texasalynn]

or try this
=CHOOSE(N2,5,15,30,50)

 

[deilert]

Thanks folks!

Turns out that Aladin works best my this application. Love it!