krodriguez
Board Regular
- Joined
- Jul 11, 2012
- Messages
- 119
Hello,
Is there a way to have a dynamic calculation for LTM...I want to get rid off =SUM(Cell1, Cell2, Cell3...Cell12) and manually change the cells once I move from month to month. Ideally the formula can detect the dates and just bring the values.
Example I have:
If I do LTM Dec-15 my results = $1200, what If I want to do LTM Jan-16 = $1300...the idea is to have a dynamic formula that will allow me to select my date, example Jan-16 and automatically calculate the LTM (so I don't mess with the formula), is this possible? Thanks
<tbody>
</tbody>
Is there a way to have a dynamic calculation for LTM...I want to get rid off =SUM(Cell1, Cell2, Cell3...Cell12) and manually change the cells once I move from month to month. Ideally the formula can detect the dates and just bring the values.
Example I have:
If I do LTM Dec-15 my results = $1200, what If I want to do LTM Jan-16 = $1300...the idea is to have a dynamic formula that will allow me to select my date, example Jan-16 and automatically calculate the LTM (so I don't mess with the formula), is this possible? Thanks
Date | Jan-15 | Feb-15 | Mar-15 | Apr-15 | May-15 | Jun-15 | Jul-15 | Aug-15 | Sep-15 | Oct-15 | Nov-15 | Dec-15 | Jan-16 |
Revenue | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 200 |
<tbody>
</tbody>