How to Add a Total Row in Excel

Do you have a table in Excel that could benefit from a row of totals? This wikiHow will teach you how to add a total row in Excel.

Steps

1
Open your project in Excel. Double-click your .xls worksheet file in File Explorer (for Windows) or Finder (for Mac). Alternatively, right-click the file and select Open with > Excel.
- If you already have Excel open, go to File > Open and open your project.
2
Click anywhere in the table. Once you click the table, you'll see the "Design" tab in the editing ribbon.

Advertisement
3
Click Design. Once you click this tab, you'll see more options for editing your table appear.
4
Click the box to select Total Row. It's in the "Table Style Options" grouping to the right of the menu.
- You'll see a row added to the bottom of your table that will list totals.
- From the drop-down menu, you can select a function, like Average, Count, Count Numbers, Max, Min, Sum, StdDev, and Var.^{[1]
  X
  Trustworthy Source
  Microsoft Support
  Technical support and product information from Microsoft.
  Go to source}
Advertisement