Seeking Assistance - Average Days Open, by Status, Month/Year

Hi All - I'm trying to calculate the average # of days for data set, where the Status is "X", and the M/Y = "Y". I'm good with "AverageIf" = label@row, but not sure how I can incorporate the date piece. Thanks in advance!

Sharing some snapshots of the data, all columns (Total Days Open, Completion Status, Leave Blank...) are within same sheet. The "Total Days Open" is functioning fine, and should be used to calculate average against the status type and the Date MM/YYYY. Last image is how I record the metrics on a separate sheet.

Find more posts tagged with

Formulas

Dashboards

Accepted answers

All comments

Paul Newcome

Have you tried an AVG/COLLECT combo?

=AVG(COLLECT({Range To Average}, {1st Criteria Range}, 1st criteria, {2nd Criteria Range}, 2nd criteria))

GregLunaP20

I have not tried the 'collect' piece, I'll give that a try now. Thanks - I'll let you know.

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.