sales chart help

I'm working on some sales charts. The chart is broken down by day and week and by division. I need a formula that adds sales by division and keeps a running total by week in a separate area of the workbook.
I am currently having to change the formulas every week which is time consuming.
The area in orange is the section of the workbook where I need the values to be returned. Any help would be appreciated.