AverageIF- Date range and multiple criteria from SS source

Hi,

I keep getting unparceable, please help!

Need the average of all days in source 1that meet this criteria: source 2 ="closed", and source 3 has a date range of 1/1/21-3/31/21.

Source 1-{Tracker Range 8}

Source 2- {Tracker Range 4}

Source 3- {Tracker Range 3}

Find more posts tagged with

Accepted answers

Mike TV

@BBIrr41

Try this:

=AVG(COLLECT({Source 1}, {Source 2}, "Closed", {Source 3}, >=DATE(2021, 1, 1), {Source 3}, <=DATE(2021, 3, 31)))

All comments

Mike TV

@BBIrr41

What type of column is Source 1? The AVERAGEIF function works on numbers. If that column is a date, it won't work on it. What would an average of a date even be? What's your expected result?

BBIrr41

@Mike TV Yes source 1 is numbers, its count of days containing a separate formula, but this column has some blanks so may need IFBLANK too.

Mike TV

@BBIrr41

Try this:

=AVG(COLLECT({Source 1}, {Source 2}, "Closed", {Source 3}, >=DATE(2021, 1, 1), {Source 3}, <=DATE(2021, 3, 31)))

BBIrr41

@Mike TV Thanks!! It worked!

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.