I want to calculate the surface under a segment of line BF: y = x (see image below)
via pythagoras the following can be deduced:
When substituting: b-a = n
In Excel column BF specifies the y(x)
surface under BF in excel: SUMIF(INDIRECT(“BF"&a & ":BF"&b),"<>#N/A")
when putting the first formula in excel, it only mimics the indirect function when adding +1 for segment n: 0.5(n+1)(d-c)+c(n+1)
Why do I have to do that, how does excel approach the indirect function exactly?!!!
@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 this video to see that and others.