johnbird1988
Board Regular
- Joined
- Oct 6, 2009
- Messages
- 199
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
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