SUM Function in Excel
In this tutorial, you will learn about how to use SUM formula in excel. SUM function in excel itself often used for the operational of arithmetic and data processing purpose in this spreadsheet software. Let’s learn it so you can be more adept in processing your data!
Why We Need to Learn About SUM Formula in Excel?
In processing data especially in the form of numbers, often we need to do addition operation between them so we can get the result that we want and to analyze the data further. Things like company total revenue which can be gained from the addition process of all product sales in a time period, budget total for a marketing campaign from the addition process of all requirement needs for the marketing communication media payment, and other things are examples where addition operation is needed to get a picture which can be used as the base to determine next decision in a job or business.
In this spreadsheet tool, there is SUM function in excel which is the base of the helper feature to do addition operation which is provided by Microsoft in this software. SUM formula in excel is very crucial to be understood by the users of this spreadsheet tool so they can process data excellently because addition is one of the basic data processing like the explanation earlier. For that, if you have not completely understood about this feature, let’s learn deeper on this tutorial so you can understand completely about this SUM formula in excel!
What is SUM Function in Excel?
SUM function in excel is a formula in this spreadsheet tool which can be used for numbers addition process so the process can be much more effective and efficient. This formula also has variants like SUMIF to do addition process with specific condition, which is explained deeper in other tutorial part in this Compute Expert blog.
A little bit explanation about the inputs in this formula is as follows:
=SUM(number1, number2, …)
Note:
number1, number2, … = all the numbers to be summed
How to Use SUM Formula in Excel?
Following is the guidance on how to use SUM formula in excel. The way to use SUM function in excel is almost the same as other formula in the beginning, with the number inputs which are want to be processed will be inputted in it.
Using SUM Function in Excel

Type equal sign ( = ) in the cell where you want to put the calculation result

Type SUM (can be with large and small letters) and open bracket sign after =

Type the numbers or cell coordinates where you put the numbers to be addition processed are after open bracket sign with comma sign ( , ) between the numbers or cell coordinates or drag cell cursor from the most top left cell coordinate to the most bottom right if the number cells you want to process are close to each other

Type close bracket sign after all the numbers or cell coordinates filled with numbers have already been inputted
 Press Enter

The process is done!
Exercise
After you have learned how to do SUM function in excel, you can practice your understanding about how to use SUM formula in excel by doing addition process on this exercise!
Download file from the following link and answer the questions below. Please download the answer if you have done doing the addition process using SUM function in excel to answer the questions in the exercise and sure about the results!
Link to download file to train your skill in using SUM formula in excel:
Download here
Questions
 What is the addition process result of all numbers in first column? Use SUM function in excel to answer it!
 What is the addition process result of all numbers in second column? Avoid black colored cell when giving the number inputs!
 What is the addition process result of all numbers in first column? Avoid black colored cell when giving the number inputs!
Link to download answer:
Download here
Additional Notes
 In using SUM formula in excel, drag cell cursor and numbers or cell coordinates input with comma sign separation can be done in one writing
 If you want, cell coordinates which are near to each other can also be written manually separated for the most top left cell and most bottom right cell by two dots sign ( : ) (e.g. SUM(A1:B30)
 This function has variants such as SUMIF which can be used if you have specific criteria for the digits which you want to include in addition process for the SUM formula in excel. The learning about this formula can be learned in other part of tutorial in this Compute Expert blog!