Forum Discussion
Solved
Automatically changing search or summing ranges
Hi, I am trying to create a formula where you enter a week number, in a separate cell and then sum a given number of weeks going forwards from that point, from another separate cell. The idea is that...
- Wow, thank you so much!! I've been fighting this one for hours and just going round in circles
Wow, thank you so much!! I've been fighting this one for hours and just going round in circles
TrevB Not a very straight-forward formula, but it's was the first that came to mind. If you have Excel for MS365 or 2021, there are (most likely) a dozen other approaches to this case.