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 :

=IF(NO.WEEK(B2)=NO. WEEK(B3);"";SUM(C:C))

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.

=SUM.IF($A$2:A2;A2;$C$2:C2)

Warning, respect the $.