Hey Guys,

Lets say I have Cell A1 = 10

Is there a way to have B1 = SUM(A1:A[1+10])?

Basically adjusting how many cells are summed based on the provided value in A1.

Likewise, would there be a way to have C1 = D[A1]?

Thanks!