Forum Discussion
Solved
Specific SUM formula
Hello all, I am working with a table consisting of three columns. One column has months, the other has revenues and in the 3rd column I need the sum of the last 12 months of revenue. This means t...
dzhogov , for the model like this
you may use
=SUM(INDEX(B:B,ROW()-MIN(12,ROW()-ROW($A$1)+1)+1):INDEX(B:B,ROW()))
in C2 and drag it down.
dzhogov , you are welcome