Cumulative Sum Excel

[ajd]

i would like to ask, is there a function to sum a number for a given number of times retaining the cumulative total. For example 100 for 5 times, cumulative should read (100*1)+(100*2)+(100*3)+(100*4)+(100*5)=1500. Does this function exist where you input 100 and 5 and get a 1500 result?

[mrice]

You can do this with a user defined function.

Please Login or Register  to view this content.

Hit Alt F11 to get to the VBA editor
Insert - Module
Paste in the above code.
Alt F11 back to Worksheet
Enter into a cell =Cumulative(100,5)

[martindwilson]

=A1*SUMPRODUCT(--(ROW($A$1:$A$200)<=A2),ROW($A$1:$A$200))
where a1=100 and a2 is the number of times you want summed ie 5
=1500
or if
a1=20
a2=10
=1100
err why is this post in the introduce yourself forum?

[SSH]

Hi I am new to this forum and I have a question on the cumulative sum function

Year
0 a*1.1^0
1 a*1.1^1 + 1*1.1^0
2 a*1.1^2 + a*1.1^1+a*1.1^0
3 and so on

Is there a formula can put this together? i tried the VBA code. The answer is not correct somehow.

Thanks

[jeffreybrown]

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.