I have an Excel sheet with two columns:
- A - contain the days of the week (Mon, Twe, Wed, Thu, Fri - maybe rarely even Sat and Sun)
- B - contain a number
The records may contain not a fixed amount of records for each day, so for example
Mon can appear in 3 consecutive rows, while
Tue only once. So for a week we have more records than the days in one week. Also the days of the week in column
A are sorted.
What I want is the sum of those number based when week changes.
By change of the week it mean when we have on first record
Fri and in the next
How can I write a formula in
C column that it shows the result in the last day of each week?