S Oberlander
Board Regular
- Joined
- Nov 25, 2020
- Messages
- 147
- Office Version
- 365
- Platform
- Windows
In my excel sheet column A is a list of dates, column B is total sales volume for that day, I need totals by week at the end of every week
so in column C I have this formula:
and in column D I have:
Is there any way to use just one formula for this?
so in column C I have this formula:
Excel Formula:
=WEEKNUM(A2,1)
Excel Formula:
=IF(WEEKDAY(A2,1)=7,SUMIF(C:C,C2,B:B),"")