AVG(Collect formula with multiple criteria

Giselle Torres

Hello:

Im trying to figure it out how to calculate the average "Days to Closed" for each "Task Owner" in 2021 ("Year"column ). I was trying Avg(collect formula. But i get #invalid ref error.

The formulas i try :

=AVG(COLLECT({Days to Closed}, {Task Owner}, "Chris Jularbal", {Year}, IFERROR(YEAR(@cell), 0) = 2021))

and

=AVG(COLLECT([Days to Closed]:[Days to Closed], [Task Owner]:[Task Owner], "Chris Jularbal", {Year}, "2021"))

Thank you in advance for your help!

Giselle

Giselle Torres

Ok finally, this work for me :

=AVG(COLLECT([Days to Closed]:[Days to Closed], [Task Owner]:[Task Owner], "Chris Jularbal", Year:Year, "2021"))

Giselle Torres

Ok finally, this work for me :

=AVG(COLLECT([Days to Closed]:[Days to Closed], [Task Owner]:[Task Owner], "Chris Jularbal", Year:Year, "2021"))