Forum Discussion
Calculating the average
Hi All, i have this data where i need to find the average number of open issues owned by an individual per month for 2022 and 2023. This data contains open date and due date(open date is when issue was notified to the individual and closed date is when the issue is resolved), if there is no closed date then the issue is still open. thanks in advance.
=SUMPRODUCT(($B$2:$B$25=$I4)*($E$2:$E$25="")*(MONTH($D$2:$D$25)=J$3)*(YEAR($D$2:$D$25)=J$2))
Attached is my suggestion with SUMPRODUCT. It calculates the number of open issues per individual, year and month and then takes the average with SUM divided by the number of months.
