I am looking to create a formula that counts the avg number of days issues go past due per Depts.

AnnaQ

I have a column calculating days past due for each row and a column categorizing each issue to a department. Now I am wanting to combine this information and calculate the average number of days that issues are going past due per each department. For example, all rows with Finance in the Department column will have their number of days based due column averaged.

Paul H

AnnaQ

Thank you Paul! I appreciate the quick response.