Sum daily to weekly using OFFSET and SUMIF functions

[noossab]

Hi all. I am working on a spreadsheet in order to calculate daily cost, accumulated and individual. I would like to add in col 6 (O6) a condition to sum the cost week by week, and show only in the last day of the week, Sunday for instance.

the sheet is attached here: example-sample.xlsm

Thank you.

[Ace_XL]

In O6
=IF(COUNTIF(N6:$N$14,N6)=1,SUMIF($N$6:$N$14,N6,$B$6:$B$14),"")

Copy down

[noossab]

Hi thank you for your reply. The function works, however my goal was not to fix cells as I the sheet will be filled to the 31st, so there will be 30 or 31 daily value. Plus I have to detect the beginning or end of the week to sum the previous six days plus this day, that's why I was thinking about the offset function. I used this formula but it did not work: =SUMIF((offset(C5,-6,0):C6,O6">="O7,O6))