Tom’s Tutorials For Excel: Quickly Summing a Table of Numbers by Rows and Columns


Share Button

Tom’s Tutorials For Excel: Quickly Summing a Table of Numbers by Rows and Columns

Here are a couple of shortcuts to quickly sum the totals for rows and columns in a data table.

The first pair of pictures shows what you have and what you want.
The second pair of pictures shows the familiar SUM formulas.
The third pair of pictures shows quicker methods using AutoSum or Alt+=.





Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , , , ,

Leave a Reply

Your email address will not be published. Required fields are marked *

*