How can I get information from cells with data by condition?

Question

excel

Task:
There are cyclically repeating columns by dates, where the number of sales and earnings are indicated -
prntscr.com/ibxsff (Day 1-4)
Need: determine the number of days for which the last 5 sales were made (highlighted in gray) and calculate the amount for these days (yellow column).
For me, this is the only way so far:
if sales on day 4 >=5, return the data;
if sales on day 3+4 >=5, return, etc. But the number of days is theoretically infinite (added daily), respectively, through "if" it will be an infinite formula. It is also not possible to determine "by eye" the number of sales, because they are very chaotic. It can be either 100 per day or 0 throughout the year.
I hope I explained myself quite clearly. Thank you.

Answer 1

Initially incorrectly presented data is difficult to analyze.
You first make the correct normalized table, and make the visualization separately (pivot table for example).
Then there will be no such pain.