I would like to request Experts help. How to make sure the Sumproduct value that was copied from "Daily Tracking List" only extract data based on Start Date and End Date (Column B and C - Chart). Currently the formula extracted all data even though it's outside of Start/End date. E.g. Cell at F2 "TH3" (Chart sheet), Start/End date for week-1 is "31-Jan to 6-Feb", by right only data from this date need to be captured from "Daily Tracking List", however the cell extracted data from 6-Jan onwards. How to prevent this?. Hope Experts will help me to refine this Sumproduct formua.
=IF(TODAY()<$B2,"",100-(SUMPRODUCT(('Daily Tracking List'!$B$2:$B$196<=$C2)*('Daily Tracking List'!$D$2:$D$196=D$1)*('Daily Tracking List'!$I$2:$I$196="Yes")*'Daily Tracking List'!$H$2:$H$196)*1440)/(10080*ROWS(D$2:D2))*100)