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.

Find more posts tagged with

Accepted answers

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.