Total Data In Excel Table. If the table or range contains hidden cells you can use SUBTOTAL to include or exclude those hidden cells and this is the biggest difference between SUM and SUBTOTAL functions. Add Data to Excel Table If you like to show the Total row in an Excel table you dont need to hide that row when its time to add data at the bottom of the table.
To give a custom name to your table. Also Excel table totals are automatically adjusted as new rows are added to the table. Once the table is ready to use click on the last cell of its last column and press Tab key to create a new row.
Turning the Total Row on and off for an Excel Table is easy.
Or go to the Design tab Table Style Options group and select the Total Row box. Please do as follows. You can also add a function from the total row drop-down. Excel Tables make some calculations like totals or averages automatic.