Formula to sum ranges based on criteria with sum range moving based on date criteria

Hi all,

I have income and expenditure data which is listed by days. I need to pull this data into another tab and group weekly (by end of week). so I need a formula that sumifs by income/expenditure type if the date falls between the end of the week and the beginning of the week.

I have attached a file with example data. I need the formula in Sheet 1 tab in D13:N21 and D26:N35 based on the data in the bank tab. So D14 is Reg fees for week ending 3/9/23 and that should total £600 and E14 should equal £1,200.

Thanks in advance.

James

Another way in D14

Please Login or Register  to view this content.

copied down and across.

Great, thank you that worked. Much appreciated.

You are welcome.