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

Jose31_0-1646454739195.png

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!

2 Replies

  • YukiK's avatar
    YukiK
    Icon for Impactful Individual rankImpactful Individual
    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