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

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

How To Use INDEX-MATCH Formula The VLOOKUP formula searches for a value in the first column of an array and returns a value to the right of that array. How about if you wanted to return a value to the left hand side of that array? Well, this is where the INDEX-MATCH formula comes in and gives you a helpi...
Show The Difference From Previous Years With Excel... Excel Pivot Tables have heaps of calculations under the SHOW VALUES AS option and one that gets the most use is the DIFFERENCE FROM calculation. You can show the values as the Difference From previous months, years, day etc.  This is just great when your boss asks you how you ...
Fix Excel Hyperlinks to a Named Range Hyperlinks in Excel must be one of the funkiest features that I love playing around with! They allow you to create interactive buttons within Excel (without the need to create a Macro) and you can make them take you to any cell or range within your Excel worksheet. One shor...
INDIRECT Function in Excel What does it do? Returns a reference to a range. The referenced range can be a cell, a range of cells, or a named range. Formula breakdown: =INDIRECT(ref_text, ) What it means: =INDIRECT(Return the referenced range, Omit if the reference is an A1 style or enter FAL...