You may need to create totals for several rows and columns in a worksheet, such as for each year, or for each store, as in our example.
First select the table containing the data and the empty cells to the bottom and the right where you would like totals to be added.
In the ribbon’s Home tab, in the Editing section towards the right, click the AutoSum button, or use the keyboard shortcut by holding down the Alt key and pressing =. (If using Microsoft Excel 2003 or earlier, click the AutoSum button on the Standard toolbar.)
Totals are generated in the blank cells to the right and to the bottom in your selection.