AVERAGEIF with OR function

Hi —

I'm trying to write a formula that captures the average of the CD column only IF it's in the CD, permitting, or construction phase. Below it only has 2 of the phases; i'm not sure how to incorporate the third.

My current formula is giving the #INVALID DATA TYPE error:

=AVERAGEIF(OR({Metric.Phase}, "5.Permitting", {Metric.Phase}, "6. Construction"), {Metric.CD})

Thank you!

Find more posts tagged with

Formulas

Accepted answers

All comments

jjg279

You can't have multiple criteria for AVERAGEIF, you will want to use AVG(COLLECT(OR instead. If I read your ranges right something like this should work:

=AVG(COLLECT({Metric.CD}, {Metric.Phase}, OR(@cell = "6.Construction", @cell = "5.Permitting", @cell="OTHERTHING)))

Paul Newcome

You could still use the AVERAGEIF in this case…

=AVERAGEIF({Metric.Phase},OR(@cell = "5.Permitting", @cell = "6. Construction"), {Metric.CD})

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.