Excel In Seconds Tips and Tricks from The Excel Addict - Microsoft Excel 2003, 2007, 2010, 2013, 2016, 365


January 31, 2017

Greetings from The Excel Addict

Hi fellow Excel Addict,

In today's 'Excel in Seconds' tip, I'm going to reveal 'Secrets of the AutoSum Function'.

If you missed my last 'Excel in Minutes' tip, 'Custom Formatting for Your Headers and Footers', you can read it here now.


Please feel free to share my newsletter with your Excel friends — they will thank you for it.

Hope you're having a great week and keep on Excelling,
Francis Hayes (The Excel Addict)
Email: 
fhayes[AT]TheExcelAddict.com


Francis Hayes (TheExcelAddict.com)


TheExcelAddict.com Quote of the Day

"Success is not the key to happiness.
Happiness is the key to success.
If you love what you are doing, you will be successful."

-- Albert Schweitzer --




If you missed my last newsletter, you can click here to view it online.




Excel in Seconds with TheExcelAddict.com

Secrets of the AutoSum Function

Every Excel user knows how to use the SUM function to total to a row or column of numbers.

You simply type =SUM into a cell, or use the keyboard shortcut ALT+= or click the AutoSum (Σ) command found on the righthand side of the Home tab.

Basic Excel SUM Function in Microsoft Excel 2007 2010 2013 2016 365

When you are not on the Home tab, the AutoSum command is not visible, so if you're really smart, you will have added the AutoSum command to your Quick Access Toolbar so it's always easily accessible.


What you may not have noticed is that the AutoSum command on the Home tab has a small dropdown arrow next to it. Click on it and you will discover that, in addition to SUM, you also have a choice of using the AVERAGE, COUNT NUMS, MAX or MIN functions in the same way. Click the small dropdown, the click the function you want to use.

Alternatively, if you prefer using keyboard shortcuts, pressing ALT then H activates the Home tab, press U to reveal the AutoSum options and then press shortcut key (S, A, C, M, I, F) for whichever function you want to use.

Excel will suggest a range to use, the same ways as with the SUM function, press Enter to accept or drag to select a different range.

AutoSum Secrets in Microsoft Excel 2007 2010 2013 2016 365
If you click the More functions... option, it will open the Insert Function dialog.

Insert More Worksheet Functions in Microsoft Excel 2007 2010 2013 2016 365




If you've found this tip helpful, please click here to share it.




Thanks for supporting this newsletter and website

Earnings Disclosure: Some of the resources I recommend on my website and in my newsletter pay me a small referral commission if you purchase from them through links on my website or using my referral code. This helps offset the costs of my website. I've worked long and hard to build up my reputation online over the past 10 years as someone who provides exceptional value to my readers. So I'm not willing to risk that for a few dollars. As you know, I don’t just recommend anything. It has to be of outstanding quality and value. If you are ever not completely satisfied with anything I recommend, please let me know and I will get your money back for you...GUARANTEED. You can't lose.
 'Spreadsheets Tips From An Excel Addict' and 'Excel in Seconds' are publications of TheExcelAddict.com.
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630