Cumulative Sum

[kk]

Hi

Current I'm using a sum formula =Sum($G$1,E1) and drag down starting from E1
to get the cumulative sum of each cell, and stop at the cell until it
reaches the upper limit number specify in another cell $H$1.

Example:

E F G H
0.25 0.25 1
0.5
0.75
1


How do I convert this to an array formula by specify the fixed number in
$G$1 and the total cumulative sum cannot greater than the number specify in
$H$1?


Thanks!

kk

 

[Arvi Laanemets]

Hi

=MIN($H$1,(ROW()-1)*$G$1)