Hello all,
Is it possible to calculate the cumulative total of a range using SUM and INDEX formulae?
Example below:
snip.PNG
I'm comfortable with using an INDEX formula to return the value against one line (ie, index 5 would return the value in B6).
What I need to do is get the formula to calculate the sum of B2:B6 when the index is 5, B2:B7 when the index is 6, etc etc.
Hope I have explained this properly!
Thanks in advance.
Bookmarks