Secrets of the AutoSum Function in Excel!

Every MS Excel user knows well how to use the SUM function.

Simply you type =SUM into a cell, use the Shortcut ALT+= and click the AutoSum (Ʃ) command found on the right side of the Home Tab.

AUTOSUMAUTOSUM

As you know well, when you are not on the Home Tab the AutoSum command is not visible and if you want to always use the AutoSum you may add the AutoSum command to your Quick Access Toolbar, so it will be always accessible to you.

I thought you never noticed that the AutoSum command on the home Tab has a tiny drop down arrow next to it, click on the tiny drop down arrow and you will discover some other function instead of Sum, you can chose to calculate AVERAGE, COUNT NUMBERS, MAX and MINS in the same way you use SUM, choice is yours.

AUTOSUM

You can also use keyboard shortcuts, press ALT+H to activate the Home Tab, press U to activate AutoSum options and then press shortcut keys for which function you want to use:

S = Sum

A = Average

C = Count Numbers

M = Max

I =  Min

F = More Functions

Excel will suggest you a range for use the same way with the SUM, press Enter to accept the range or select other range.

If you know any other things about AutoSum, Let me know!

Advertisements

The URI to TrackBack this entry is: https://powertipsntricks.wordpress.com/2017/02/05/secrets-of-the-autosum-function-in-excel/trackback/

RSS feed for comments on this post.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: