Median with criteria

Hello!

I am trying to get the median days to complete for anything that is Bank of America, Chase Bank, etc. etc..

I have tried using the entire column in the formula and also specifying the specific cells and both returned with errors.

The formulas I have used are the following:

=MEDIAN(COLLECT({Days to Complete}, {Current Custodian}, "BANK OF AMERICA N.A"))

=MEDIAN(COLLECT([Days to Complete]1:[Days to Complete]1136, [Current Custodian]1:[Current Custodian]1136, "BANK OF AMERICA N.A"))

Your help is greatly appreciated.

Find more posts tagged with

Formulas

collect

Accepted answers

All comments

Paul Newcome

What errors are you getting with those formulas, and is the formula going on the same sheet as the source data or a different sheet?

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.