Total the data in an Excel table

You can quickly total the data in a Microsoft Office Excel table by displaying a totals row at the end of the table and then by using the functions that are provided in drop-down lists for each totals row cell. A Total row is a row that automatically calculates totals, and it keeps track of values you enter as you enter them. It can also give you total averages and counts, among other options.

  1. Enter your data in the workbook, and click any single cell within the set.

    Excel workbook with values.
  2. Click Insert > Table. The Create Table dialog box opens.

    The Table option is on the Insert tab.
  3. Review the cells selected in the Create Table dialog box. If you have headers for each column of data, select the check box for My table has headers.

    The Create Table dialog box.

    Tip: You can also use your cursor to select what cells to include in your table. With the Create Table dialog box open, click the first cell in the first column that contains your data. Drag your cursor to select your cells.

  4. Click OK to create your table.

  5. Click any cell in your table. Then click Design, and select the check box for Total Row.

    The Total Row option is on the Design tab.
  6. The Total row is inserted at the bottom of your table.

    A new Total row appears.

    Tip: By using the drop-down menu for the Total value, you can change the calculation for the total row. Use this to quickly find the average, count, or maximum value.

    Change to type of Total by selecting from the drop-down menu.

See Also

Create or delete an Excel table in the worksheet

Subtotal and total fields in a PivotTable report

Add subtotals in a PivotTable

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!