Finding Average of Cells in Another Sheet

RingJake

Hello,

I am trying to find the average of "% completes" percentages from one sheet to another that meet a certain criteria.

Here is the formula I have attempted however, I am receiving an "Invalid Operation". Is there a way to accomplish this without selecting each cell individually?

=IF({Team} = "Marketing", AVG({% Complete}))

RingJake

Terrific, thank you!

Justin L

Try AVERAGEIF

For example, a "Dept" column and a "Progress" column:

=AVERAGEIF(Dept:Dept, "Marketing", Progress:Progress)

https://help.smartsheet.com/function/averageif

RingJake

Terrific, thank you!