Forum Discussion
Syndicate_Admin
Administrator
AdministratorAverage 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.
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!
YukiK
Impactful Individual
Impactful IndividualYou 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!