Average with a Criteria

Options

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.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!