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!

			Amount	Cumulative
Amount	100		100	100
Iterations	3		100	200
			100	300
				600

<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[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.