I am trying to average ratings by category.

I am trying to average customer satisfaction ratings by category within our marketing department — for example, market research, graphic design, etc. Here are the two formulas I've tried:

=AVERAGEIF({Marketing + Communications Request Log Category}, CONTAINS("Brand", {Marketing + Communications Request Log Category}), {Marketing + Communications Request Log Rec})

=AVERAGEIF({Marketing + Communications Request Log Category}, "*Marketing*", {Marketing + Communications Request Log Rec})

… where Category is the text of the project's category and Rec is the project's numerical score for Recommendation (out of 5).

However, the formula is returning 0 (not unparseable, just 0) for all categories. What am I doing wrong? Thanks in advance!

Find more posts tagged with

Accepted answers

Paul Newcome

Try something like this:

=AVG(COLLECT({Range To Average}, {Category}, CONTAINS("Brand", @cell)))

Make sure to leave the @cell exactly as it is. You should only need to update the {Cross Sheet References}.

All comments

Paul Newcome

Try something like this:

=AVG(COLLECT({Range To Average}, {Category}, CONTAINS("Brand", @cell)))

Make sure to leave the @cell exactly as it is. You should only need to update the {Cross Sheet References}.

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.