NumberMuncher
New Member
- Joined
- Jul 20, 2015
- Messages
- 16
- Office Version
- 365
- Platform
- Windows
Hi,
I have a data table with movements every month. This is then summarised into a report using INDEX MATCH MATCH. This is perfect for month to month.
But how do I sum these so it will add the movement of the month to the sum of the previous months (YTD result)?
<tbody>
</tbody>
<tbody>
</tbody>
Thank you in advance!
I have a data table with movements every month. This is then summarised into a report using INDEX MATCH MATCH. This is perfect for month to month.
But how do I sum these so it will add the movement of the month to the sum of the previous months (YTD result)?
Result required | Jun 2015 |
Cash at Bank | 13,250.00 |
<tbody>
</tbody>
Info provided | Jan 2015 | Feb 2015 | Mar 2015 | Apr 2015 | May 2015 | Jun 2015 |
Cash at Bank | 2,500.00 | 3,000.00 | 5,000.00 | 1,000.00 | 750.00 | 1,000.00 |
<tbody>
</tbody>
Thank you in advance!