Total Rows and Columns at the Same Time Using AutoSum

Excel’s AutoSum button provides one-click access to several aggregrate functions: Sum, Average, Count Numbers, Max and Min. But you don’t have to total rows and columns separately - you can calculate them at the same time.

To Total Adjacent Rows and Columns at the Same Time:

1. Highlight the range you want to total. Be sure to include an extra row and column for the formulas.
   
2. Click the arrow on the AutoSum button on the Home tab of the Ribbon or the Formulas tab of the Ribbon.
   
3. Select the function you want from the drop-down list.
4. Excel will enter in the formulas in both the seleted rows and the selected columns.

You’re not only limited to adjacent rows and columns. You can also total non-adjacent rows and columns at the same time. It involves only one extra step: selecting the additional rows & columns.

To Total Non-Adjacent Rows and Columns at the Same Time:

1. Highlight the first range you want to total. Be sure to include an extra row and column for the formulas.
2. Hold down the Ctrl key and highlight the second range you want to total, also including an extra row and column for the formulas.
   
3. Click the arrow on the AutoSum button on the Home tab of the Ribbon or the Formulas tab of the Ribbon.
4. Select the function you want from the drop-down list.
5. Excel will enter in the formulas in both the selected rows and the selected columns for both ranges.