Jan 04 2022 05:50 AM
If the dropdown value of the list (weeks of an year) matches with a vlookup array of values, then the corresponding values have to be pulled AND, have to be summed up until the selected weeks of the year.
Jan 04 2022 06:08 AM
That could be
=SUM(
INDEX(<A range>, MATCH(<week # range>, <weeks range>, 0) ):
INDEX(<A range>, COUNTA(<week # range>)) )
Jan 04 2022 07:43 AM
=SUM(INDIRECT(("D3:D"&MATCH(F5,C3:C26,0)+2)))
Maybe with above formula as shown in attached file.