Hello, Trying to recreate a formula i wrote in a previous role to track duration for a monthly average. My formula is written as so:
=IFERROR(SUMIFS({Duration}, {Duration}, ISNUMBER(@cell), {End}, ISDATE(@cell), {End}, (IFERROR(MONTH(@cell), 0) = 1), {End}, (IFERROR(YEAR(@cell), 0) = 2024)) / COUNTIFS({Duration}, ISNUMBER(@cell), {End}, ISDATE(@cell), {Duration}, (IFERROR(MONTH(@cell), 0) = 1), {End}, (IFERROR(YEAR(@cell), 0) = 2024)), 0)
on my source sheet {Duration} is calculated in this formula =IFERROR(NETWORKDAYS([Initial Call]@row, [First Bill Emailed]@row), 0) / 12
My date column is in the date formatting. Not sure why I am getting no return on the first formula i should have an average for January as 1.96
