I need the updated sum from 1st to the current date-CodePudding

I have extracted the cell address of the current date by using:

=CELL("Address",INDEX($H$4:$AK$4,MATCH(G3,H4:$AK$4,1)))

G3 contains the day number of the month.

Now I need to use the Sum formula in G6 such that it adds the values from 1st to the current date which is updated by the function Today() in cell G1.

Is there a way I can use the Sum function to use the address inside the cell rather than the address of the cell.

SS of the sheet

You can download the sheet from here.

CodePudding user response：

I think you are making it too difficult. Just use SUMIF, and make the criteria that the dates are less than today.

=SUMIF(date_range, "<"&TODAY(), sum_range)