Hi,
I'm a newbie on the forum and tried search to find some help to my simple problem: I have a sheet with months as columns (currently 12*13 years and expect this to grow each year). I have multiple rows with information from other sheets in he same workbook. Now I want to gather this information to another sheet so that it's summarized in quarters (and further in years).
I tried the following formula, which I found by googling:
=SUM(OFFSET('Cash Flow M'!$A21;0;3*COLUMNS('Cash Flow M'!$A21:A21)-3;1;3))
I want to be able to easily copy this downwards and to the right. I did it, but when I go to column N in quarterly sheet, which I expect to calculate cells AL20, AM20, AN20 from the monthly sheet. Unfortunately it doesn't, I can see it from he result. The calculation is:
=SUM(OFFSET('Cash Flow M'!$A20;0;3*COLUMNS('Cash Flow M'!$A20:M20)-3;1;3))
As I'm just experimenting with OFFSET for the first time, I can't solve it by myself. Could someone help me? How should I copy this formula so that it works as I expect?
Thanks in advance!
Bookmarks