Formula Friday – Auto Sum Packs A Punch With This Cool Trick


Friday again, time for #formulafriday. 

You can download todays example here.

[wpdm_package id=’9896′]

Ok, so you are probably saying AUTOSUM, really?. Whats special about that then?.  Yes we use it a lot- or I do whether is via Ribbon

  • Home Tab
  • Editing Group
  • AutoSum

OR

use the KEYBOARD SHORTCUT ALT+= 

But….it also can do really really cool stuff, not just sum your columns of data.  How about when you have a data set that looks like this?.

autosum3

 

Autosum will automatically sum your rows and columns in the same way as it does with just a column of data all at the same time!.

  • Highlight the data set and the cells where you want to hold the summed values (I have highlighted the cell in green in my example).

autosum4

  • Use the Ribbon method or the keyboard shortcut to populate the cells with one click click.

Fast as that- how cool.  Autosum packs a little more punch.
I hoped you like liked today’s #formulafriday.

More Excel Tips_New1

Dont forget to sign up to the Excel at Excel Newletter for 3 free Excel tips the first Wednesday of the month. Just click on the Sign Up Form to the right or use the link below.

 

th
Excel Expert Course

Barbara

Barbara is an experienced data analyst with over 20 years of experience. Author of the How To Excel At Excel Top 50 Excel tips Ebook, YouTuber and Excel Blogger.

Recent Posts