Summing Multiple Criteria with moving date column

Thanks Jeff.

That works a treat in the example workbook but when I substitute it into my workbook and make the appropriate reference changes, I get #VALUE errors. Any ideas why?

Diana