Jan 27 2020 03:59 AM - edited Jan 27 2020 03:59 AM
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
Jan 27 2020 04:07 AM
Jan 27 2020 04:46 AM