mercredi 5 avril 2017

Excel function array formula based on sumif to find minimum count

I have some data where I want to find the minimum number of days it takes to reach a total sum based on some criteria.

Essentially the data is like this:

Date Season Receival
1/11/2006 2006 500 2/11/2006 2006 100 .... 10/12/2009 2009 300

etc

Want I want to do is find a formula that finds the minimum number of days it takes to reach a receivals total for the season.

 =MIN(COUNT(IF(SUMIFS(C:C,B:B,"2006")>2000,DATA!A:A)))

It doesn't matter what point it starts from, but it must take the minimum number of days to reach the 2000.

Cheers!

Aucun commentaire:

Enregistrer un commentaire