Sum by week and day with Excel

You need to calculate the sum for the day, and for the week on an Excel sheet.

You have tried the formula :


But it didn’t work. How to remedy it ?

The most simple is to get the formula from the A column on all the height and then use the formula on the second like to get the weekly total day by day.


Warning, respect the $.