Formula help change every week

[zone709]

=SUM(C6,E6,G6,I6,K6,M6,O6,Q6,S6,U6,W6,Y6,AA6)

I have so many tabs i have to change every week and update formula. I wanted to see if i can make formula above change every Monday of the week and add next column. You can see it skips every column.

trying to see if this can change very Monday. So next Monday it would add AC6, then next Monday would be AE6

=SUM(C6,E6,G6,I6,K6,M6,O6,Q6,S6,U6,W6,Y6,AA6,AC6)

=SUM(C6,E6,G6,I6,K6,M6,O6,Q6,S6,U6,W6,Y6,AA6,AC6,AE6)

Possible?

 

[rollis13]

This could be a solution as long as there is no text in the cells and beside:
=SUMPRODUCT((MOD(COLUMN($C$6:$IV$6),2)=1)*($C$6:$IV$6))
The formula is limited to column IV.

 

[zone709]

Hi not working and i cant add from C and every column. I need to always skip a column as you can see in this =SUM(C6,E6,G6,I6,K6,M6,O6,Q6,S6,U6,W6,Y6,AA6,AC6,AE6)

 

[rollis13]

Since your data starts from column C (= 3rd, odd number) and you need to skip 1 cell that's what this part of the formula is for: ),2)=1)