Cumulative Sum

[lshkolnik]

I'm looking for a formula that will sum the cumulative based on a fixed amount and number of iterations. For example, the amount is 100 and the iterations is 3. So the answer is 600. 100+100*2+100*3. I want to be able to change the fixed amount and number of iterations to calculate the cumulative sum. Thank you!

[TABLE="width: 330"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Amount[/TD]
[TD]Cumulative[/TD]
[/TR]
[TR]
[TD]Amount[/TD]
[TD] 100[/TD]
[TD][/TD]
[TD]100[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]Iterations[/TD]
[TD] 3[/TD]
[TD][/TD]
[TD]100[/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]100[/TD]
[TD]300[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]600[/TD]
[/TR]
</tbody>[/TABLE]

 

[Tetra201]

With 100 in cell B2 and 3 in cell B3, try

=B2*B3/2*(1+B3)

 

[lshkolnik]

Thank you so much!

 

[Tetra201]

You are welcome.