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)

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

"kk" <kkc...@yahoo.com> wrote in message
news:O9SrWpjc...@TK2MSFTNGP10.phx.gbl...