Average in rows

[Syndicate_Admin]

hello, I need to calculate please, a row that has percentages in some cells

thanks for your help, sorry I am a beginner.

[v-henryk-mstf]

Hi @Syndicate_Admin ，

Whether the advice given by @YukiK  has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.

Looking forward to your feedback.

Best Regards,
Henry

[YukiK · Accepted solution]

You can either pivot your data and use AVG() function for the consolidated row for all the percentages values, or you can simply do something like

DIVIDE( percentage1 + percentage2 + percentage3, 3)

Hope this helps!