I could maybe figure this out on my own, but it will take you guys a few seconds.

I have a bunch of cells(every other cell in a row) I want to add up and then dump the data every week into a specific cell. Something like:

If(new week) ( (sum of each row(every other cell)add to total) reset these cells to 0)

I could even manuallly type in a 0 or 1 to dump the data instead of having to get the day of the week. That might be better considering I may not open it every week. I don't want to have a function in every cell. Please let me know if this is clear.