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 $.