Forum Discussion
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.
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!
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!