Average with a Criteria


I am looking to generate the average age of graduate students for each year. What was the average age of the student body for class of 2022 for example?

How do I do this? I tried this:

=AVERAGEIF({Students Range 6},, {Students Range 5}, "2022")

Student range 6 are the list of ages. Student range 5 is the academic year/class. It is saying #UNPARSEABLE.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!