# 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

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.

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

Ha - you're the man!

##### Users Browsing this Thread

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

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1