Calculating Unsorted Data

Hi All-
Hope I can explain this with little confusion. I want to be able to sum the last x data points of unsorted data. For instance, I have two columns

Dates and Units. The dates are entered but they are not in the correct order. Then I have the corresponding units for the dates. I don't want to sort the data because of various reasons. I want to be able to take the last 2 (or x) dates entered and sum the the corresponding units.

Try this formula:

=SUMPRODUCT((A2:A8>=LARGE(A2:A8,2))*(B2:B8))

You can change the green 2 above to the x number of largest dates in column A.

HTH

Jason

Hi Jason, I tried it and that works great. I am going to change the green number to a name so I can make it flexible. You are awesome. Thanks!

Glad it helped. Please mark the thread solved. Thanks.

Jason