Forum Discussion
Service Request Tracking when data is indefinite
I am trying to track service requests per month. This is the information I am recording: Request Due Date Actual Month Delivered Actual Date Delivered 1 1/10/23 Jan 1/10/23 2 1/...
In cell C14 is this formula:
=SUMPRODUCT(($C$2:$C$10=A14)*($D$2:$D$10<=$B$2:$B$10))In cell D14 is this formula for the average days between due date and delivery date:
=AVERAGE(IF($C$2:$C$10=A14,$B$2:$B$10-$D$2:$D$10))Enter this formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.