Pinterest Pixel

Autosum an Array of Data in Excel

  Want to know how to use Arrays to SUM Data in Excel? *** Watch our video... read more

Download Excel Workbook
John Michaloudis
Posted on

Steps To Follow

Overview

Autosum an Array of Data in Excel | MyExcelOnline Autosum an Array of Data in Excel | MyExcelOnline

 

Want to know how to use Arrays to SUM Data in Excel?

*** Watch our video and step by step guide below with free downloadable Excel workbook to practice ***

Watch on YouTube and give it a thumbs up 👍

Autosum an Array of Data in Excel | MyExcelOnline
When you have an array of data in Excel with Totals at the bottom and to the right of the data, you can quickly fill in the Totals with the Autosum button.

STEP 1: Highlight your data including the “Totals” row and column;

Autosum an Array of Data in Excel

STEP 2: Click the Autosum button (under the Home or Formulas tabs) and this will fill in the Totals cells with the Sum formula.

Autosum an Array of Data in Excel

Aftewards both your Total row and column are now populated!
Autosum an Array of Data in Excel

Download workbookAutosum-an-array-of-data.xlsx

 

 

If you like this Excel tip, please share it
Autosum an Array of Data in Excel | MyExcelOnline Autosum an Array of Data in Excel | MyExcelOnline
See also  Copy The Cell Above In Excel
Founder & Chief Inspirational Officer at MyExcelOnline.com

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship Academy Online Course.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...