Hi there,
I have a sheet that presents values in 6 monthly periods and I would like to show same values annually (12 month period). I have managed to do it as per the formula on row 7 of the attached sample workbook. However, I used the same approach in row 8 in order to capture annually the cumulative amounts in row 4, however it didn't work, probably because the amounts are cumulative. It may be that another formula would be appropriate with respect to cumulative value.
Any assistance would be appreciated.
Regards
Ben
Bookmarks