Click the lower part of the 
Row Totals button and/or 
Column Totals button in the Totals group on the Table ribbon tab.
Select the required methods of totals calculation in the drop-down menu of the buttons:
Displaying of totals can be set up for table rows and columns. For example, the sum of column values cab be displayed in columns.
NOTE. When ranking is used, totals may contain incorrect values. The user is prompted to disable ranking before totals calculation.
To set up calculation of totals:
Click the lower part of the Row Totals button and/or Column Totals button in the Totals group on the Table ribbon tab.
Select the required methods of totals calculation in the drop-down menu of the buttons:
Sum.
Average.
Minimum.
Maximum.
Number of Non-Empty.
Number of Empty.
Mode.
Median.
Variance.
Root-Mean-Square Deviation.
Skewness.
Kurtosis.
Range.
Variation Coefficient.
Sum of Squares.
First-Order Autocorrelation.
Upper Decile.
Upper Quartile.
Lower Quartile.
Lower Decile.
Total.
TIP. Several methods can be applied at the same time when calculating totals. For example, the user can display sum and mean of column values.
To hide totals:
Click the Row Totals button and/or Column Totals button.
Select the None option in the drop-down menu of the button.
Example of row totals:
Example of column totals:
To set up additional parameters of totals, use the Totals dialog box.
TIP. To quickly set up totals, use the Totals tab on the side panel.
Set options in the dialog box:
Table of methods of totals calculation
Format totals by rows or by columns
Calculate totals by hierarchy/Calculate totals by levels
See also:
button.
button.
