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.

DOWNLOAD WORKBOOK

Autosum an array of data

HELPFUL RESOURCE:

ctrlShiftEnter

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

Share on Google+

Related Posts

Add Leading Zeros in Excel Do you have a lot of numbers with an uneven number of digits in your Excel list?Do you want to make them uniform by adding leading zeros to them?Well, it's a pain to add zeros in front of them one by one!Thankfully, Excel allows you to add leading zeros with one singl...
Sum the Last 7 Transactions with the Offset Functi... What does it do?It returns a reference to a range, from a starting point to a specified number of rows, columns, height and width of cellsFormula breakdown:=OFFSET(reference, rows, columns, , )What it means:=OFFSET(start in this cell, go up/down a number of ro...
Consolidate with 3D Formulas in Excel 3D Formulas or References in Excel are a great way to consolidate data from multiple sheets.3D Formulas reference several worksheets that have the same structure which allows you to consolidate by using the SUM function.Formula breakdown:SUM(Sheet1:Sheet4!A1)...
INDEX Function with Data Validation To make the INDEX function in Excel interactive we can add a Data Validation drop down list.By referencing the second argument in the INDEX function - the Row Number - to a data validation list, will allow a user to choose the nth position of a list and return their respectiv...