SUMIF last five date for a particular product

[johnbird1988]

Hello,

I am struggling to think how I can do this with a SUMIFS or SUMPRODUCT function.

I have a list of Products and their Sale Date and Sale Amounts. What I would like to do is a SUM of all the Sale Amount for each Product, but only the last five Sale (using the Sale Date) I could get the MAX Sale Date but not sure to the get the 5th Sale Date for the range.

Thank you for your help.

John

 

[Aladin Akyurek]

Works perfectly thank you Aladin, sorry again for the mix up and changing the requirements. I appreciate your help. Thank you John

No problem. You are welcome.