01/11/09 | 1.12 |
01/12/09 | 2.23 |
01/01/10 | 1.45 |
01/02/10 | -1.68 |
01/03/10 | 2.01 |
01/04/10 | -1.77 |
01/05/10 | 1.34 |
01/06/10 | 1.76 |
01/07/10 | 2.34 |
01/08/10 | -1.23 |
01/09/10 | 1.76 |
01/10/10 | 2.45 |
01/11/10 | -1.56 |
01/12/10 | 1.65 |
01/01/11 | 2.34 |
01/02/11 | 1.90 |
I have a table like the above, but larger 2009-2017, and want to calculate yearly cumulative returns (where RHS % returns) is there a simple way to do this, currently playing round with =AVERAGEIFS(Returns!B2:B98,Returns!A2:A98,">=01-Jan-2015",Returns!A2:A98,"<=31-Dec-2015") but I would like the cumulative yearly retuen, not the yearly average. Any help appreciated!! | |
<tbody>
</tbody>