Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago
Solved

Average in rows

hello, I need to calculate please, a row that has percentages in some cells thanks for your help, sorry I am a beginner.
  • YukiK's avatar
    YukiK
    4 years ago

    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!

v-henryk-mstf's avatar
v-henryk-mstf
Icon for Community Support rankCommunity Support
4 years ago

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