I need a function that allows me to plug in 2 numbers in 2 square, and have a 3. square get the SUM from a row, between two lines in the column, for instance, if I plug in 5 and 9 in the first to squares, the third should take the sum from A5 to A9, and give the SUM of all the numbers between them, including them.
So far I have tried using a Lookup function (danish langauge), as shown on the attatched file, but I can't figure out how to get the sum for all rows between and including the two selected.
Solved by X. W. in 27 mins