AverageIf Statement Not Right

Lindsay AR
Lindsay AR ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions


I am trying to get the average of a column based on the owner. The range is a column with a formula resulting in a number (=[Planned % Complete]@row- [Actual Complete]@row). The criteria is a contact column.  My formula is as follows:

=AVERAGEIF({What The Frog 1}, CONTAINS("Big Bird", {What The Frog 2}))

I have tried several different ways, but continue to get a return of 0. I also tried SumIf, but that did not work either. *Note, I am referencing a different sheet

Thanks for the guidance!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!