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 ***
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!