Excel - How to using the SUM function

By Laura

SUM function in Excel is often used to calculate the sum of numbers on a spreadsheet. Using Sum function will help you save a lot of time and effort compared with conventional manual calculations.

To better understand the syntax and how to use SUM function in Excel, Betdownload.com will guide you how to effectively use SUM function in many specific cases.

Excel - How to using the SUM function

Syntax: = SUM (number 1, number 2, ...)

Function: Calculate the sum of number 1, number 2, ect

In which: number 1, number 2, ect is the number that you want to calculate.


- the cell with logic value TRUE is considered as 1, FALSE is considered as 0.

- If the number is a reference, only values ​​in the reference will be counted. The other values ​​ are ignored.

Example 1:

= SUM (1, 2, 3) by 6.

= SUM (2, 3, TRUE) by 6.

= SUM ("2", "3", 1) by 6.

Example 2: A table of items to be paid:

- Apply SUM function to plus all the money in the Payment column (D4: D6) and put that value in cell D7.

- The formula: D7= SUM (D4: D6) to select all the values ​​from D4 to D6. We have the results as shown below

You have just learnt the SUM function, its operation is extremely simple. Also, you can learn more functions for calculating the sum of available conditions as SUMIF function, ect to perform calculations on a spreadsheet with multiple conditions.

Related Articles:
Excel – LARGE function, returning largest value number k
Excel – Examples and guidance for VALUE function- a function for converting string to number
Excel - Connect strings having quotation marks, the CONCATENATE function
Excel – Round function – round number in Excel
Excel – HLOOKUP function - a search function in Excel
Excel – COUNTA function – count data cells




sum function in excel


the function sum


sum function Excel 2003

, Excel 2007 function sum sum function excel 2010 2013 excel sum function

Related software

Latest update

Copyright BETDOWNLOAD.COM © 2014 - All rights reserved