I have a workbook with two spreadsheets. One is 'Daily Profit and Loss' and looks like this:
Date | Profit 01/01/01 | £1 01/02/02 | £-1
And another is 'Weekly Profit and Loss'
Week Beginning | Profit ...
How can I get the sum profit per week in the 'Weekly Profit and Loss' spreadsheet?