Average duration for specific owners

jcubsmoo

Hello,

I am trying to create a formula that averages the days from a "duration" column for a specific project owner (I have the project owners listed in "Column 7"). I continue to get an "Invalid Operation" message.

Formula:

=AVG(COLLECT({CSS Prioritization Duration}, {Owner}, HAS([Column7]@row)))

Zachary Hall

I think using AVERAGEIF() would be the best way to calculate this. It would look like:

• =AVERAGEIF({Owner}, CONTAINS([Column7]@row,@cell),{CSS Prioritization Duration})

Hope this helps!