In Excel, you can total all the data in a table by adding a Total Row, and from there, choose a function that suits your needs.
Total Row
First, click anywhere inside the table to activate the Table Tools ribbon menu on the top.
Then, click on Table Tools, go to Design, and click on the check box next to Total Row.
This will add the Total Row at the bottom of your table, like this:
While the Total Row sums up the numbers by default, you can click on a cell in the Total Row, and click the drop-down menu to choose among different formulas.
