Total Rows and Columns at the Same Time Using AutoSum
Posted by Roger Hyttinen on
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:
- Highlight the range you want to total. Be sure to include an extra row and column for the formulas.
- Click the arrow on the AutoSum button on the Home tab of the Ribbon or the Formulas tab of the Ribbon.
- Select the function you want from the drop-down list.
- 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:
- Highlight the first range you want to total. Be sure to include an extra row and column for the formulas.
- Hold down the Ctrl key and highlight the second range you want to total, also including an extra row and column for the formulas.
- Click the arrow on the AutoSum button on the Home tab of the Ribbon or the Formulas tab of the Ribbon.
- Select the function you want from the drop-down list.
- Excel will enter in the formulas in both the selected rows and the selected columns for both ranges.
Share this post
- Tags: Excel, Microsoft Office Tips