How to ADD consecutive values in a Lookup Table

Here is an example:

I have a table, and I need to add (SUM) several consecutive numbers from this table, taking into consideration the starting index and the amount of numbers to add:

Start Index: 4
Number of Cells: 3
RESULT: 345

        INDEX   VALUE          1   500          2   300          3   190          4   135          5   110          6   100          7   90          8   85          9   80          10  75          11  70  

https://stackoverflow.com/questions/65818926/how-to-add-consecutive-values-in-a-lookup-table January 21, 2021 at 07:01AM