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.
Answers

The error is coming from the extra comma after the first range.
You will still need to rearrange the pieces a bit though to have the correct syntax.
=AVERAGEIF({Students Range 5}, "2022", {Students Range 6})
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!