Cumulative Sum

Hi

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

--
Arvi Laanemets
( My real mail address: arvil<at>tarkon.ee )



"kk" <[email protected]> wrote in message
news:[email protected]...
> 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

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<at>tarkon.ee )



"kk" <[email protected]> wrote in message
news:[email protected]...
> 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
>