How to Sum in Excel


Home >> How to Use Excel Tutorial >> Excel Calculations >> 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)

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

    How to Sum in Excel - Screenshot of Step 1-1

  2. 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

    How to Sum in Excel - Screenshot of Step 1-2

  3. Press Enter
  4. The process of how to sum in excel is done!

    How to Sum in Excel - Screenshot of Step 1-4



Method 2: SUM

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

    How to Sum in Excel - Screenshot of Step 2-1

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

    How to Sum in Excel - Screenshot of Step 2-2

  3. 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 top-left cell to the most bottom right if each number is close in location

    How to Sum in Excel - Screenshot of Step 2-3

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

    How to Sum in Excel - Screenshot of Step 2-4

  5. Press Enter
  6. The process of how to sum in excel is done!

    How to Sum in Excel - Screenshot of Step 2-6



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.

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

    How to Sum in Excel - Screenshot of Step 3-1

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

    How to Sum in Excel - Screenshot of Step 3-2

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

    How to Sum in Excel - Screenshot of Step 3-3

  4. 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

    How to Sum in Excel - Screenshot of Step 3-4

  5. 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

    How to Sum in Excel - Screenshot of Step 3-5

  6. Type a close bracket sign

    How to Sum in Excel - Screenshot of Step 3-6

  7. Press Enter
  8. The process of how to sum in excel is done!

    How to Sum in Excel - Screenshot of Step 3-8



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

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

    How to Sum in Excel - Screenshot of Step 4-1

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

    How to Sum in Excel - Screenshot of Step 4-2

  3. 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 ( , )

    How to Sum in Excel - Screenshot of Step 4-3

  4. 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

    How to Sum in Excel - Screenshot of Step 4-4

  5. 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

    How to Sum in Excel - Screenshot of Step 4-5

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

    How to Sum in Excel - Screenshot of Step 4-6

  7. Type a close bracket sign after all the digit conditions and criteria have been inputted

    How to Sum in Excel - Screenshot of Step 4-7

  8. Press Enter
  9. The process of how to sum in excel is done!

    How to Sum in Excel - Screenshot of Step 4-9



Method 5: AutoSum

This method can be used if the number that you want to add are in one vertical/horizontal sequence.
  1. 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

    How to Sum in Excel - Screenshot of Step 5-1

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

    How to Sum in Excel - Screenshot of Step 5-2-1

    How to Sum in Excel - Screenshot of Step 5-2-2

  3. Press Enter
  4. The process is done!

    How to Sum in Excel - Screenshot of Step 5-4



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

  1. How many is the number of total students from all classes?
  2. How many is the number of total students for class A? Use SUMIF to answer!
  3. 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.

How to Sum in Excel - Screenshot of Additional Note



Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!


Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!



Follow our tutorial content also on


CONTACT US PRIVACY POLICY TERMS AND CONDITION AFFILIATE DISCLOSURE @Compute Expert