Cumulative Sum
 

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

Hi

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

--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )



"kk" wrote in message
...
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