Can you help me with a formula to calculate the following:
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?
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?