I am trying to average ratings by category.

CHarter89 · 03/17/25

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!

Paul Newcome · 03/17/25

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}.

Paul Newcome · 03/17/25

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}.

Formulas and Functions

Formulas and Functions

I am trying to average ratings by category.

Best Answer

Answers

Help Article Resources

Quick Links

Categories

Trending in Formulas and Functions

Formula to return a date when value in one sheet matches value in another.

COUNTIF with CONTAINS Error – Looking for a Solution

Formula not working in some cells of column