Average with a Criteria

Raquel C

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.

Paul Newcome

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})