Would someone be able to help me modify an existing formula or rewrite it so that if any combination of the multiple criteria are met, it will find the average time elapsed?
If "Non-Urgent" in column A and "Approved" in column E or if "Non-Urgent" in column A and "Denied" in column E, then subtract Final Date/Time in column D from Initial Date/Time in column B then divide by the number of Responses that are "Approved" or "Denied" in column E.
The calculation I have now does not return the correct anwer of 0:30:
SUMPRODUCT(--('Detail Information'!G2:G1000="Approved")+('Detail Information'!G2:G1000="Denied"),('Detail Information'!F2:F1000-'Detail Information'!E2:E1000))/SUM(COUNTIF('Detail Information'!G2:G1000,{"Approved","Denied"}))
Bookmarks