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 | MyExcelOnline

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 | MyExcelOnline

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

DOWNLOAD WORKBOOK

 

HELPFUL RESOURCE:

How to Combine VLOOKUP and IFERROR to Replace the #N/A Error in Excel

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn