Blog

AutoSum Multiple Rows and Columns

Work smarter, not harder! Excel TipAutoSum Multiple Rows and Columns

Many Excel users are familiar with the AutoSum feature but may not realize the power behind the button! Use this tip to sum multiple rows and columns with a single click.

“Magically” AutoSum Multiple Rows and Columns

 Scenario: Our worksheet contains many rows and columns of sales data that we want to sum both vertically and horizontally. To do this:

  1.  Select the data to sum plus the blank row below the data and the blank column to the right of the data where the totals will display.
  2. On the “Home” tab, in the “Editing” group, click the AutoSum button. Totals are calculated and appear in the last row and in the last column of the selected range!

Watch the video below and see how to filter records for unique values and copy to a different worksheet.

If you need help or information about this tip, contact us and we’ll be happy to go over it with you.