Using SUMIFS with only the last few data of a column ?

[iparout]

Hi.

I am posting a sample worksheet and a screenshot from it to make my point more clear.

Sample.jpg

Sales.xlsx

I have successfully used SUMIFS in order to calculate the income of a specific salesperson up to the date I am interested (in our example, E17 represents the total income of Tom up to the 29th of August).

What I want to do now is :

1) Be able to use SUMIFS in order to sum up only the last 4 of Tom's entries. In our example, for the 29th of August, this should add up D17+D14+D13+D11)

2) Be able to use SUMIFS in order to sum up all entries of Tom for the last month (30 calendar days). In our example, for the 4th of September, this should add up D19+D17+D14+D13+D11+D10+D7).

Is there any way to do this or am I asking too much ?

Thanks a lot.