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 👍
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;
STEP 2: Click the Autosum button (under the Home or Formulas tabs) and this will fill in the Totals cells with the Sum formula.
Aftewards both your Total row and column are now populated!
DOWNLOAD WORKBOOK