 # Getting simple formula to sum columns A-X where the columns summed depends on value in another cell

Highlighted
Occasional Contributor

# Getting simple formula to sum columns A-X where the columns summed depends on value in another cell

This simple formula in cells H9 and H11 sums the values of the weeks to the right. Currently as the weeks progress I am updating the range manually . eg on week 4 telling it to sum from range I9-L9 . However what i want it todo is sum the right columns depending on the week number in another cell.

So for this week (week 5 ) is knows to sum I9-M9

originally I was just using sum I-BH and capturing the whole year, however people want to pre-enter values in future weeks (as forecast) and so I want to avoid counting them unless in THAT week as it messes up the statistics from the tables 3 Replies
Highlighted

# Re: Getting simple formula to sum columns A-X where the columns summed depends on value in another c

For H9 that could be

``=SUM(I9:INDEX(I9:BH9,ISOWEEKNUM(TODAY())))``

Highlighted

# Re: Getting simple formula to sum columns A-X where the columns summed depends on value in another c

That was perfect, thank you

Highlighted

# Re: Getting simple formula to sum columns A-X where the columns summed depends on value in another c

@shotgun-68 , you are welcome