Looking for some assistance. I want to update my formula to extract data between the date range in cell B12 & B13, instead of just data from the start date in B12. How would I update the formula to recognize the date range?
=SUM(IF(('[Production Recap 2020.xlsm]Data'!$A$2:$A$9998=$B$12)*('[Production Recap 2020.xlsm]Data'!$B$2:$B$9998=$B$14)*('[Production Recap 2020.xlsm]Data'!$C$2:$C$9998=A16),'[Production Recap 2020.xlsm]Data'!$F$2:$F$9998))
=SUM(IF(('[Production Recap 2020.xlsm]Data'!$A$2:$A$9998=$B$12)*('[Production Recap 2020.xlsm]Data'!$B$2:$B$9998=$B$14)*('[Production Recap 2020.xlsm]Data'!$C$2:$C$9998=A16),'[Production Recap 2020.xlsm]Data'!$F$2:$F$9998))