# Formula to calculate the minimum value in a range of cells on a cumulative basis

1. ## Formula to calculate the minimum value in a range of cells on a cumulative basis

I need a formula to calculate a minimum value. The data to be analyzed in in a column ordered by period (period 0,1,2,3....,etc.). I need a formula that looks at the sum of period 0, periods 0-1, periods 0-2, periods 0-3....etc. and then pull the minimum value. Not positive this can be done w/ an Excel formula...Thanks in advance!

Excel Brain Teaser.xlsx  Register To Reply

2. ## Re: Formula to calculate the minimum value in a range of cells on a cumulative basis

=MIN(MMULT(--(ROW(D4:D20)>=TRANSPOSE(ROW(D4:D20))),D4:D20))

This is an array formula, confirmed with Ctrl+Shift+Enter.

Also, this was fun to research.  Register To Reply

3. ## Re: Formula to calculate the minimum value in a range of cells on a cumulative basis

Ha - you're the man!  Register To Reply

There are currently 1 users browsing this thread. (0 members and 1 guests) 