Hi,
I'm trying to copy a simple sum formula across a spreadsheet however when i click and drag i can't get the values right. I've attached an example to try and explain.
1. I'm trying to calculate 12 months of values on particular reporting dates
2. So in Cell E6 in have enter the formula =SUM(B2:M2) to calculate 12 months as you can see highlight orange.
3.This calculates the value total of B2:M2
4. However i need to calculate this figure annually so the next time would be in I6
5. At the moment i have enter the figure in manually because when i highlight B6:E6 and drag the value in I6 calculates the values from F2:Q2 (highlight yellow) rather than N2:Y2 (pink next 12 months) (There is no need for any calculations in cells B6,C6,D6)
6. The next problem is each property has different reporting periods
7. So F9 is the sum of E3:P3 and then when you click and drag the same issue occurs.
Does anyone have a solution?Workbook7.xlsx
Bookmarks