1 2 3 4 5 6 7

32 32 32 27 27 27 27

32 32 32 27 27 27 27

These are weeks that I want to convert into a monthly number. The weeks will roll the most current week every time I pull the report. I'm looking for a formula that would add the row of numbers that match the week numbers i input.

For example.

Jan would be 32+32+32+27=123

Is there a formula that would say if Week range is 1-4 sum so that no matter which order my weeks are in Jan would always be a sum of weeks 1-4?