I am trying to average ratings by category.

CHarter89

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

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

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