How to Sum in Excel
In this tutorial, we will learn about how to sum in excel. This calculation process can be done manually, using excel how to sum formulas, or utilizing the AutoSum feature.
Why do We Need to Learn About How to Sum in Excel?
In doing number data processing, often we need to know the result if we do the addition process to those numbers. It is sometimes needed to get an important conclusion in a data analysis that we do.
The calculation need is often found in our work. Data like the total profit of a business in a month or how many employees in the company are the examples. To get this data, the addition process is needed to be done in our spreadsheet file.
Because of that, if we often save and process our data in this software, we should understand how to sum in excel. It is so our data processing can be done much easier and faster.
What is Addition Process in Excel?
The addition process in excel is the process to add the numeric data that we have in this spreadsheet tool. It can be done manually, using formulas, or utilizing the AutoSum feature.
If we use formulas, then the standard process is by using the SUM formula. We can also use SUMIF/SUMIFS if we want to do the addition process for digits with specific criteria. To do the addition process without writing formulas, we can use the + button from our keyboard or utilizing the AutoSum feature.
How to Sum in Excel?
In the next parts, we will explain about how to sum in excel manually, using formulas, or AutoSum. How to sum in excel using formulas will be explained using the three formulas: SUM, SUMIF, and SUMIFS.
Method 1: Manual Method ( + Sign)

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

Input numbers or cell coordinates where the numbers which you want to add are after =. Input plus signs ( + ) in between those numbers or cell coordinates
 Press Enter

The process of how to sum in excel is done!
Method 2: SUM

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

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

Input the numbers or cell coordinates where you put the numbers to be processed are after the open bracket sign. Input comma signs ( , ) in between the numbers or cell coordinates. Drag cell cursor from the most topleft cell to the most bottom right if each number is close in location

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

The process of how to sum in excel is done!
Method 3: SUMIF
SUMIF can be used if you have particular criteria for numbers that you want to input in the addition process. Usually useful if you have much data and you need to get the calculation result for only some of them.
Type equal sign ( = ) in the cell where you want to put the result

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

Drag cursor on the cells where your digit condition are and type comma sign ( , )

Input the criteria for your digit condition then type a comma sign. The criteria must be inside quote signs ( “” ) if the criteria is for texts. The signs are needed too if the criteria is a more than/less than for numbers

Drag cursor on the cells where the numbers which you want to process based on the criteria are in. The digits cells must be inline vertically/horizontally with your digit condition cells and should have the same number of cells

Type a close bracket sign
 Press Enter

The process of how to sum in excel is done!
Method 4: SUMIFS
SUMIFS formula has an almost similar function with SUMIF. The only difference is you should use SUMIFS if your digit conditions are more than one
Type equal sign ( = ) in the cell where you want to put the result

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

Drag cursor on the cells where the numbers which you want to process based on your conditions later are in. Then, type a comma sign ( , )

Drag cursor on the cells where your first digit condition is and type a comma sign. The cells of the digit condition must be inline vertically/horizontally with your digit cells. They should also have the same number of cells

Input your first criteria. The criteria must be inside quote signs ( “” ) if the criteria is for texts. It is needed too if the criteria is a more than/less than for numbers

Type a comma sign after the criteria is inputted if there are still other condition(s) to be inputted. Redo actions 45 if that is the case

Type a close bracket sign after all the digit conditions and criteria have been inputted
 Press Enter

The process of how to sum in excel is done!
Method 5: AutoSum
This method can be used if the number that you want to add are in one vertical/horizontal sequence.
Place your cell cursor at the end of the row or column which consists of all the numbers that you want to sum. If there are more than one rows or columns that you want to sum the numbers in each, then do this. Drag your cursor at the end of all that rows and columns

Click Home or Formulas Tab and click AutoSum. You can also press together Alt and = (Windows) / Command, Shift, and T (Mac) buttons
 Press Enter

The process is done!
Exercise
After you learn about how to sum in excel using different methods, sharpen your understanding by doing the following exercise!
Download the exercise file from the link below and answer the questions. Download the answer file to check your results if you have done doing the exercise and sure about your answers!
Link of the exercise file:
Download here
Questions
 How many is the number of total students from all classes?
 How many is the number of total students for class A? Use SUMIF to answer!
 How many is the number of total students for class 2 and 3 with code B? Use SUMIFS to answer! (Hint: for “not the same as" criteria, use <> sign)
Link of the answer key file:
Download here
Additional Note
Make sure the digits you want to sum are not in the form of texts! This problem usually happens when those digits are collected from external data sources. The text form of the digits will make them not included in your sum process! Take a look at the following picture as an example of the situation you should avoid.