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