Forum Discussion
Sum in every 7 days
Hello Everyone😊 I want to total in every 7 days with formula. How can i do?
Excel there are a number of ways to do this. I thought you would also want a companion column to id the week # which also makes the formula easier 🙂
Week # Formula:
=UNIQUE(IFERROR(INT((A:A)/7)+1,1))Weekly Sum Formula:
=SUMIFS(B:B,A:A,">"&7*(D2#-1),A:A,"<="&7*D2#)based on the week # formula being in cell D2 as in this layout:
