Problem with average number formula, with certain criteria


Hi All!

Im trying to get the average number of a certain range, but only if it meets a certain criteria. I have looked at other examples but somehow i don't get it to work.

So I want the average of the blue columns. But only if the Red column is a certain name. And if its possible I want to do the formula on a seperate sheet??

Does anyone have any ideas how to make this work?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!