03 Useful Methods : Add Numbers With AutoSum Excel


03 Useful Methods Add Numbers With AutoSum Excel

One of the most popular functions available in Excel is the AutoSum function. Excel AutoSum automatically totals the contents of cells.

Excel AutoSum is a formula that calculates (by default) the total from the adjacent cell up to the first non-numeric cell using the SUM() function in its formula. The AutoSum feature provides a quick way to sum a contiguous range of numbers (that means there are no empty cells in a range). The range may be a single cell or thousands of cells.

The AutoSum icon is the Greek capital letter Sigma ∑. Math and Science use the Sigma ∑ as a summation operator. 

01. HOW TO USE SUM FUNCTION IN EXCEL?

The SUM function is a mathematical function in Excel that totals values in one or more cells in a range and displays the result in the cell containing the function. It is applicable for both contiguous and non-contiguous cells or ranges.

In the case of contiguous cells or ranges, select them by the dragging of the mouse or by the Shift and navigation arrows.

For non-contiguous cells or ranges, hold the CTRL-key and select them by dragging the mouse.

The syntax for the SUM function:Syntax for the SUM functionnumber1, number2,… The values we want to add

Note: Brackets [ ] indicate optional arguments; however, do not actually type the brackets when we enter the argument.

The SUM function contains one required argument (number1) that represents a range of cells to add. For example, =SUM(B3:D3). Excel will sum all cells within that range.

We can enter up to 255 arguments into the SUM() function. For example, the following formula returns the sum of the values in three separate ranges: =SUM(B3:D3,B7:D7,B10:D10).

We can apply the SUM Function in a cell with 03 different methods:

• Method 1: Apply SUM Function With ‘Formula AutoComplete Tool'

Apply SUM Function With 'Formula AutoComplete Tool'_1

(01) Select the cell where to apply SUM function ➪ place equality sign (=) and type sum, Excel by default select the SUM function from the drop-down list; otherwise select the SUM function with down navigation arrow (⬇).

Note that the upper or lower case does not matter for syntax, Excel by default considers it in upper case.  

(02) Then press the Tab key which allows us to open the SUM function with an open parenthesis.

Apply SUM Function With 'Formula AutoComplete Tool'_2

(03) Select the range.

Apply SUM Function With 'Formula AutoComplete Tool'_3

(04) Then press Ctrl+Enter or Enter to accept the formula.

• Method 2: Apply SUM Function With ‘Insert Function’ dialog box

Apply SUM Function With 'Insert Function’ dialog box_1

(01) Select the cell where to apply the SUM function.

(02) Press Shift+F3 which will open the ‘Insert Function’ dialog box. Excel automatically place an equal sign (=) in the cell.

➢ Type and Search SUM function in ‘Search for a function:’ box ➪ then click OK or,

➢ Click to choose a category from ‘Or select a category:' drop-down list, for example, select ‘Math & Trig' category and find the SUM function using the horizontal scroll bar ➪ then click OK.

Note: Excel’s built-in functions are grouped into ten categories. 

(03) As a result, the ‘Function Arguments’ dialog box appears. Depending on the individual function’s arguments, select the required cells for each argument expected by the function. We can select a cell or range of cells and Excel automatically adds the references to the argument. However, we can also type a range or cell address directly in the argument text box. 

Selects the range (i.e., B3:D3) in the Number1 box. If required, we can select multiple necessary cell references to complete all of the function’s arguments.

(04) When finished constructing the arguments, press Enter or click OK to accept the formula.

Note: Excel displays the function results in the cell and the function appears in the Formula bar. 

Apply SUM Function With 'Insert Function’ dialog box_2

• Method 3: Apply SUM Function With ‘Insert Function’ button on the Formula Bar

(01) Select the cell where to apply the SUM function.

(02) Click the Insert Function button (fx) on the formula bar which will open the ‘Insert Function’ dialog box. Excel automatically place an equal sign (=) in the cell.

Either type and search SUM function in the ‘Search for a function:’ box or click to choose a category from ‘Or select a category:' drop-down list and select the SUM function ➪ then click OK.

Apply SUM Function With 'Insert Function’ button on the Formula Bar

Alternatively, go to the ‘Formulas' tab ➪ click the ‘Insert Function’ button (fx) in the function library group.

Apply SUM Function With 'Insert Function’ button on the Formula Bar_2

(03) As a result, another ‘Function Arguments’ dialog box opens ➪ selects the range (i.e., B3:D3) in the Number1 box; similarly we can select multiple different ranges ➪ Press Enter or click OK to accept the formula.

• Method 4: Apply SUM Function With AutoSum Excel

When we apply AutoSum, Excel first checks is there any contiguous range of values above the current cell, if there are, Excel will sum the values above it; otherwise, it will check is there any values to the left of it and if there are it will sum those values. We can change the range if required.

 

Coursera Plus banner featuring Johns Hopkins University, Google, and University of Michigan courses highlighting data science career-advancing content

02. HOW TO USE AUTOSUM IN EXCEL?

We can apply the AutoSum Excel function in 03 ways:

➢ Method 1: Excel AutoSum  Shortcut (Alt+=)

(01) Click a cell beneath a contiguous range or a cell right in the contiguous range where we want to insert a sum total. 

(02) Press Alt + = which will apply the AutoSum in Excel and by default select the suggested range (or drag to select the desired range).

AutoSum Excel With Keyboard Shortcut (Alt+=)_1

(03) Finally, press the Enter key to accept the formula.

AutoSum Excel With Keyboard Shortcut (Alt+=)_2

➢ Method 2: AutoSum Excel by clicking the AutoSum Button on the ‘HOME' tab

(01) Click a cell beneath a contiguous range or a cell right in the contiguous range where we want to insert a sum total. 

(02) Go to the Home tab ➪ click the Autosum button in the Editing group. As a result, Excel by default selects the suggested range (or, drag to select the desired range).

AutoSum Excel by clicking the AutoSum Button on the 'HOME' tab

(03) Press the Enter key to accept the formula.

➢ Method 3: AutoSum Excel by clicking the AutoSum Button on the ‘FORMULAS' tab

(01) Click a cell beneath a contiguous range or a cell right in the contiguous range where we want to insert a sum total. 

(02) Go to the Formulas tab ➪ click the Autosum button in the Function Library group. Similarly, Excel by default selects the suggested range (or, drag to select the desired range).

AutoSum Excel by clicking the AutoSum Button on the 'FORMULAS' tab

(03) Press the Enter key to accept the formula.

03. HOW TO EXCEL AUTOSUM HANDLING BLANK CELLS IN A RANGE?

HOW TO EXCEL AUTOSUM HANDLING BLANK CELLS IN A RANGE_1

Excel AutoSum does not include any cells in its range after reaching a blank cell. In this case, we can change the range manually in two ways: 

(i) First select the range in the SUM() function and extend the range by Shift and Navigation keys. After the selection of the new range, press Enter to accept the change in the formula.

HOW TO EXCEL AUTOSUM HANDLING BLANK CELLS IN A RANGE_2

(ii) Another way to extend the range by dragging one of the fill handles of the selected range and extend the range so that it includes all the cells we want. Finally, press Enter to accept the change in the formula.

HOW TO EXCEL AUTOSUM HANDLING BLANK CELLS IN A RANGE_3

If you would like to improve your academic and professional career as well, then the below courses help you a lot. Instead of Advanced Excel, a number of best courses suggested you through this platform that boosts your confidence and flies your career high.
AEF_192by192
Advance Excel Forum

Premium Courses on ed2go

03 Useful Methods : Add Numbers With AutoSum Excel03 Useful Methods : Add Numbers With AutoSum Excel

Microsoft Excel 2019/Office 365 Series

Bestseller
4.9/5
03 Useful Methods : Add Numbers With AutoSum Excel03 Useful Methods : Add Numbers With AutoSum Excel

Microsoft Office Master 2019 Certification Training (Vouchers Included)

Bestseller
4.9/5
03 Useful Methods : Add Numbers With AutoSum Excel03 Useful Methods : Add Numbers With AutoSum Excel

Microsoft Excel 2019 Certification Training

Bestseller
4.9/5
03 Useful Methods : Add Numbers With AutoSum Excel03 Useful Methods : Add Numbers With AutoSum Excel

Certified Internal Auditor with Microsoft Excel 2019

 

Bestseller
4.9/5
03 Useful Methods : Add Numbers With AutoSum Excel03 Useful Methods : Add Numbers With AutoSum Excel

Executive Assistant with Microsoft Office Specialist 2019 (Vouchers Included)

Bestseller
4.9/5
03 Useful Methods : Add Numbers With AutoSum Excel03 Useful Methods : Add Numbers With AutoSum Excel

Payroll Manager

Bestseller
4.9/5

Premium Courses on Coursera

03 Useful Methods : Add Numbers With AutoSum Excel03 Useful Methods : Add Numbers With AutoSum Excel

Excel Skills for Business

Bestseller
4.9/5
03 Useful Methods : Add Numbers With AutoSum Excel03 Useful Methods : Add Numbers With AutoSum Excel

Excel Skills for Business: Intermediate I

Bestseller
4.9/5
03 Useful Methods : Add Numbers With AutoSum Excel03 Useful Methods : Add Numbers With AutoSum Excel

Excel Skills for Business: Intermediate II

Bestseller
4.9/5
03 Useful Methods : Add Numbers With AutoSum Excel03 Useful Methods : Add Numbers With AutoSum Excel

Understanding and Visualizing Data with Python

Bestseller
4.9/5
03 Useful Methods : Add Numbers With AutoSum Excel03 Useful Methods : Add Numbers With AutoSum Excel

Advanced Data Science with IBM

Bestseller
4.9/5
03 Useful Methods : Add Numbers With AutoSum Excel03 Useful Methods : Add Numbers With AutoSum Excel

Introduction to Business Analytics: Communicating with Data

Bestseller
4.9/5

Premium Courses on FutureLearn Limited

Premium Courses on Udemy

03 Useful Methods : Add Numbers With AutoSum Excel03 Useful Methods : Add Numbers With AutoSum Excel

Mastering Excel 2019 – Intermediate

Top Rated
4.8/5
03 Useful Methods : Add Numbers With AutoSum Excel03 Useful Methods : Add Numbers With AutoSum Excel

Mastering Excel 2019 – Advanced

Top Rated
4.7/5
03 Useful Methods : Add Numbers With AutoSum Excel03 Useful Methods : Add Numbers With AutoSum Excel

HR Analytics using MS Excel (Excel Analytics)

Bestseller
4.6/5
Read-More_4

Thanks for your interest joining to Advance Excel Forum community.

Something went wrong.

Join Our Community List

Subscribe to our mailing list and get interesting stuff and updates to your email inbox.


Like it? Share with your friends!

Share via

Join Our Community List

Community grow with You. * VERIFY & CONFIRM YOUR EMAIL *

Thanks for your interest joining to Advance Excel Forum community.

Fill the Correct Information.

Thanks for your interest joining to Advance Excel Forum community.

Something went wrong.

Join Our Community List

Subscribe to our mailing list and get interesting stuff and updates to your email inbox.

We use cookies to ensure that we give you the best experience on our website (by analyzing).  Please see our cookies page for further details or agree by clicking the 'Accept' button.

 

Cookie settings

Below you can choose which kind of cookies you allow on this website. Click on the "Save cookie settings" button to apply your choice.

FunctionalOur website uses functional cookies. These cookies are necessary to let our website work.

AnalyticalOur website uses analytical cookies to make it possible to analyze our website and optimize for the purpose of a.o. the usability.

Social mediaOur website places social media cookies to show you 3rd party content like YouTube and FaceBook. These cookies may track your personal data.

AdvertisingOur website places advertising cookies to show you 3rd party advertisements based on your interests. These cookies may track your personal data.

OtherOur website places 3rd party cookies from other 3rd party services which aren't Analytical, Social media or Advertising.