Forum Discussion
rolling sum with specified start and end row
Hi all, I want to calculate the surface under a segment of line BF: y = x (see image below) via pythagoras the following can be deduced: 0.5(d-c)(b-a)+c(b-a) When substituting: b-a = n 0.5n...
treg2020 hello there,
Are you just asking how the INDIRECT function works? If so, it returns a range reference from a static parameter. There are a few functions which do this. You can watch https://youtu.be/-wnqlQB_j3k to see that and others.