I have the following issue
spreadsheetissue.PNG
I want to calculate weekly totals of the above into a separate sheet (below)
spreadsheetissue2.PNG
I want to be able to drag the formula across so it automatically calculates amounts for one week. As you can see in Column L & M I have done this manually but I want to be able to drag it across and for it to calculate.
I have tried Offset Sums and I can't get it to work correctly.
Any help would be much appreciated.
Thanks in Advanced
Bookmarks