Median with criteria

Hi,

I am trying to figure out the median number of days a site is in construction IF it is a Tier I, II, or III.

I am referencing another sheet. Range 6 is referencing a column that has each site's construction duration. Range 7 is the column the lists the sites tier level.

=MEDIAN({REFRESH - MASTER TRACKING SHEET Range 6}, IF({REFRESH - MASTER TRACKING SHEET Range 7}, "Tier I"))

I've tried a handful of variations, with and without the IF statement, but I've had no luck.

I appreciate any and all help!

Find more posts tagged with

Accepted answers

All comments

aecross

That worked! Thank you so much!!! Really really appreciate your help working through this. :)

Samuel Mueller

Wooo! Glad we got it working 🤣

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.