Forum Discussion
Solved
Average days to close between dates for specific person
Hey, I'm trying to create a formula that will calculate the average number of days for a ticket to be closed based on a particular person between 2 dates. I have a tab named Archived which has th...
In E4:
=IFERROR(AVERAGEIFS(Archived!$F$2:$F$15,Archived!$B$2:$B$15,M$1,Archived!$E$2:$E$15,">="&M4,Archived!$E$2:$E$15,"<="&N4),"-")
Copy down to E6, then copy to K4:K6 and to Q4:Q6
In E4:
=IFERROR(AVERAGEIFS(Archived!$F$2:$F$15,Archived!$B$2:$B$15,M$1,Archived!$E$2:$E$15,">="&M4,Archived!$E$2:$E$15,"<="&N4),"-")
Copy down to E6, then copy to K4:K6 and to Q4:Q6
HansVogelaar Thank you for your help, this worked.