How can we help you?

In the total row of the table, you can select a different type of calculation for each column. To do this, follow these steps:

1.Select the cell in the total row under the desired column.

2.Click the drop_menu_button button next to the selected cell.

3.In the drop-down menu, select the desired function. The selected function together with the column are automatically substituted into the SUBTOTAL function, and the calculation result is displayed in the selected cell.

4.If the required function is not in the list, select More functions and insert the required function in the standard way using the Insert Function pane.

To clear a calculation from a cell in the total row, select the desired cell and do one of the following:

1.Press Delete.

2.Click the drop_menu_button button next to the selected cell and chose the None option from the drop-down menu.

Was this helpful?
Yes
No
Previous
Add a calculated column
Next
Convert a table to a regular range