How to Calculate Table Columns

Please follow the steps below to calculate table columns:

Step 1: To get the sum the rows in the Table, highlight the cells below the table;

Step 2: Click the "Home" Tab from the Ribbon;

Step 3: Click "AutoSum" from the "Editing" section;

Step 4: Sum of each column will display in the highlighted row;

Step 5: Sum can turn into different measures such as average, max, min, or count. To change into a different calculation type, click the cell with the total and then click the triangle on the right, select the measurement from the drop-down list.

Leave a Reply