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
TrevB This one should work.
=SUM(INDEX(P6:AE6,MATCH($B$2,P$2:AE$2,0)):OFFSET(INDEX(P6:AE6,MATCH(B2,P$2:AE$2,0)),0,$F$2))- 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.