SpreadsheetPhil
New Member
- Joined
- Feb 25, 2020
- Messages
- 9
- Office Version
- 2016
- Platform
- Windows
I'm trying to SUM the financial data in a column on an Excel Data Table if it has a date within another column that falls between 2 dates. I've tried the below formula, but it just keeps on returning £0.00. No idea where I'm going wrong. Can anyone help?
=SUMPRODUCT(SUBTOTAL(9,OFFSET($G$2:$G$2654,ROW($G$2:$G$2654)-MIN(ROW($G$2:$G$2654)),,1)),--($D$2:$D$2654>=1/1/2014),--($D$2:$D$2654<=31/12/2014))
=SUMPRODUCT(SUBTOTAL(9,OFFSET($G$2:$G$2654,ROW($G$2:$G$2654)-MIN(ROW($G$2:$G$2654)),,1)),--($D$2:$D$2654>=1/1/2014),--($D$2:$D$2654<=31/12/2014))