Need help calculating the average of a column based on multiple criteria.

I am attempting to average the number of days to complete Action Items based on multiple criteria. I am using the =AVG(COLLECT) formula below but it is not calculating correctly. Any suggestions?

=AVG(COLLECT({5S& Safety Observations Range 3}, {5S& Safety Observations Range 1}, $Jan$1), {5S& Safety Observations Month Name}, $Jan26, {5S& Safety Observations Range 6}, $[Primary Column]@row)

Find more posts tagged with

Accepted answers

Samuel Mueller

@dminor764 are you getting any errors?

=AVG(COLLECT({5S& Safety Observations Range 3}, {5S& Safety Observations Range 1}, $Jan$1, {5S& Safety Observations Month Name}, $Jan26, {5S& Safety Observations Range 6}, $[Primary Column]@row))

looks like you may have had an extra parentheses, try the above

dminor764

Yes, that worked thank you.

All comments

Samuel Mueller

@dminor764 are you getting any errors?

=AVG(COLLECT({5S& Safety Observations Range 3}, {5S& Safety Observations Range 1}, $Jan$1, {5S& Safety Observations Month Name}, $Jan26, {5S& Safety Observations Range 6}, $[Primary Column]@row))

looks like you may have had an extra parentheses, try the above

Paul Newcome

Try moving the closing parenthesis after the first criteria to the very end of the formula.

dminor764

Yes, that worked thank you.

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.