Advice on putting values in table

[mahmed1]

Hiya

I have a table where I have a simple sumif formula to calculate for each week

Each week when I run an update, I need to paste the week I’m running as values so the table will have inconsistent table formula

my question is that can I do that so the table formula can have cells in between as values and if yes, is this the best way to approach it and if not, what is the best way to do it?

thank
you

 

[mahmed1]

Any luck