Sumifs Formula to Sum B:B, based on the earliest X amount of C:C (date column)

I'm just trying to do a sum a column based on the lowest X values in that column. I can do it below, but I don't want to do the {1,2,3,4...}.... instead I'm looking for the cumulative of the lowest X values that would do the same thing.

The X would be in a separate column, and I'd want it to add cumulatively the lowest 5 values, or 10 values or 4 values.... whatever a 3rd column h

=SUM(LARGE($C$4:$C$20,{1,2,3,4,5,6,7,8,9,10}))

For example, I would write =SUMIFS(C:C,A:A,13, -TOP X Values, in this case 3-....

The X would be a value someone on the sheet. I hope I'm explaining this correctly, as I feel it should be simple. Essentially I want to make this formula, =SUM(LARGE($C$4:$C$20,{1,2,3,4,5,6,7,8,9,10})) , but instead of typing 1,2,3,4,5,6,7,8,9,10 just tell it to sum cumulatively the top 10 or lowest 10. And that number (10) would need to be taken from a cell on the sheet, as it won't ALWAYS be 10. It could be different variables.

Product ID Date Quantity Sold Days to Sum
13 4/01/2015 2 3
13 4/02/2015 1 3
13 4/03/2015 0 3
13 4/04/2015 8 3
13 4/05/2015 21 3

Thank you, but the small and large won't work because it just returns the 5th value in this case. I want the sum of those values, not just the 5th one. (the 1st,2nd,3rd,4th,5th all together).

I've attached a clean workbook as requested.

Sum Column C if Column A = 13, and give me the top X Values, where X is Column D
This would give me the sum of column C for Product ID 13 for the firsr 6 days

This would be 34

So, first off thank you both it does work that way (i knew it had to be easier).... but I can't seem to do it for dates.

Now I could find a convoluted way of making 4/1/15 = 1, and 4/2/15 = 2 and do it that way (I test it and it works..), but is there a way to do it SMALL with a column of dates (column B in my file)? If so I should have everything I need!

Thanks guys

So, your day idea worked; up to a point.


The problem is when you fill that down past a new product ID, where there are multiple day 1's (4/1/15), and day 2's, (4/2/15), etc.

I've attached it, but It seems the sum of large(x) breaks down within the Sumifs when you have multiple ID's.

The first Result should be 34, and the 2nd should be 55.

(attached)

You may want to take a look at this, it relies heavily on FDibbins' formula, slightly modified to make allowance for the duplicate dates by using a helper column.

Summing sales.xlsx

Hope this helps

Clever.

That will work, and is dynamic enough for me to use it for this massive project.

Thank you all for your help on this; great community.

Ryan

Your Welcome and thanks for the feedback. Please mark the thread "Solved" and add to the reputation of anyone (esp. FDibbins who did the heavy lifting) who helped.