Formulas Question - Referencing Another Sheet

Tjewers

Good morning,

I am trying to pull calculate an average from data being pulled from another sheet. I want to be able to calculate the average duration, by month of completed projects.

I basically want to say what is the average of the duration fields if the phase is completed and the end date column is in the month of January and the year 2022.

What is the easiest way to do this every way I try to end up with an error.

Thank you,

Tiffany

Paul Newcome

You are going to need an AVG/COLLECT.

=AVG(COLLECT({Duration Column}, {Phase Column}, @cell = "Complete", {Date Column}, AND(IFERROR(MONTH(@cell), 0) = 1, IFERROR(YEAR(@cell), 0) = 2022))