Table of Contents
How to Sum in Microsoft Excel
Microsoft Excel is a powerful spreadsheet tool that allows users to analyze and manipulate data with ease. One of the most basic and useful features of Excel is the ability to perform mathematical operations, such as addition, subtraction, multiplication, and division. In this article, we'll focus on one of these operations – the sum – and show you how to use it in Excel.
What is the Sum Function?
The sum function in Excel allows you to add up a range of numbers quickly and easily. Rather than manually typing in each number and adding them up yourself, the sum function does the math for you. This function is especially useful when working with large sets of data, as it can save you a significant amount of time and effort.
How to Use the Sum Function in Excel
Using the sum function in Excel is straightforward. Here are the steps:
 Select the cell where you want the result of the sum to appear.
 Type "=SUM(" into the formula bar.
 Select the range of cells that you want to sum.
 Close the parentheses and hit enter.
Let's illustrate this with an example. Suppose we have a table with the following data:
A  B  C 

5  10  15 
20  25  30 
35  40  45 
To sum up the first column, we would select cell A4, type "=SUM(", and then select cells A1:A3. The formula would look like this:
=SUM(A1:A3)
Hit enter, and the result (60) will appear in cell A4.
Using the AutoSum Button
If you don't want to type out the formula manually, Excel provides a shortcut with the AutoSum button. The AutoSum button is located in the "Editing" group on the "Home" tab.
To use the AutoSum button, follow these steps:
 Select the cell where you want the result of the sum to appear.
 Click the AutoSum button.
 Excel will automatically select what it thinks is the range of cells you want to sum. If Excel has guessed correctly, hit enter. If not, adjust the range of cells manually and hit enter.
Using the SUMIF Function
The sum function is useful for adding up all of the numbers in a range, but what if you only want to add up certain numbers based on specific criteria? This is where the SUMIF function comes in handy.
The SUMIF function allows you to sum up a range of numbers based on a condition. For example, let's suppose we have a list of sales figures for different products. We want to know the total sales for Product A. We could use the SUMIF function to do this.
Here are the steps:
 Select the cell where you want the result of the sum to appear.
 Type "=SUMIF(" into the formula bar.
 Select the range of cells that contain the criteria you want to match (in this case, the list of products).
 Type the criteria you want to match (in this case, "Product A").
 Select the range of cells that contain the numbers you want to sum.
 Close the parentheses and hit enter.
The formula would look like this:
=SUMIF(A1:A10,"Product A",B1:B10)
Hit enter, and the result (125) will appear in the selected cell.
Using the SUMIFS Function
The SUMIFS function is similar to the SUMIF function, but it allows you to sum up a range of numbers based on multiple conditions. For example, let's suppose we have a list of sales figures for different products and different regions. We want to know the total sales for Product A in the East region. We could use the SUMIFS function to do this.
Here are the steps:
 Select the cell where you want the result of the sum to appear.
 Type "=SUMIFS(" into the formula bar.
 Select the range of cells that contain the numbers you want to sum.
 Select the range of cells that contain the criteria you want to match for the first condition (in this case, the list of products).
 Type the criteria you want to match for the first condition (in this case, "Product A").
 Select the range of cells that contain the criteria you want to match for the second condition (in this case, the list of regions).
 Type the criteria you want to match for the second condition (in this case, "East").
 Close the parentheses and hit enter.
The formula would look like this:
=SUMIFS(B1:B10,A1:A10,"Product A",C1:C10,"East")
Hit enter, and the result (50) will appear in the selected cell.
Using the SUMPRODUCT Function
The SUMPRODUCT function is a versatile function that allows you to multiply corresponding values in multiple arrays and then sum the products. For example, let's suppose we have two arrays – one with prices and one with quantities – and we want to calculate the total revenue.
Here are the steps:
 Select the cell where you want the result of the sum to appear.
 Type "=SUMPRODUCT(" into the formula bar.
 Select the first array (in this case, the array of prices).
 Type "*" (the multiplication symbol).
 Select the second array (in this case, the array of quantities).
 Close the parentheses and hit enter.
The formula would look like this:
=SUMPRODUCT(B1:B10,C1:C10)
Hit enter, and the result (1625) will appear in the selected cell.
Conclusion
Using the sum function in Excel is a simple yet powerful way to quickly add up a range of numbers. Whether you're working with a small or large set of data, the sum function can save you time and effort. Additionally, the SUMIF, SUMIFS, and SUMPRODUCT functions allow you to perform more complex calculations based on specific criteria. With these tools at your disposal, you can analyze and manipulate data with ease in Excel.
FAQs

What is the shortcut to use the sum function in Excel?
 The shortcut to use the sum function in Excel is the AutoSum button, which is located in the "Editing" group on the "Home" tab.

How do I use the SUMIF function in Excel?
 To use the SUMIF function in Excel, you need to select the cell where you want the result of the sum to appear, type "=SUMIF(" into the formula bar, select the range of cells that contain the criteria you want to match, type the criteria you want to match, select the range of cells that contain the numbers you want to sum, close the parentheses, and hit enter.

How do I use the SUMIFS function in Excel?
 To use the SUMIFS function in Excel, you need to select the cell where you want the result of the sum to appear, type "=SUMIFS(" into the formula bar, select the range of cells that contain the numbers you want to sum, select the range of cells that contain the criteria you want to match for the first condition, type the criteria you want to match for the first condition, select the range of cells that contain the criteria you want to match for the second condition, type the criteria you want to match for the second condition, close the parentheses, and hit enter.

How do I use the SUMPRODUCT function in Excel?
 To use the SUMPRODUCT function in Excel, you need to select the cell where you want the result of the sum to appear, type "=SUMPRODUCT(" into the formula bar, select the first array, type "*" (the multiplication symbol), select the second array, close the parentheses, and hit enter.

Can I use the sum function in Excel to add up nonnumeric cells?
 No, the sum function in Excel only works with numeric cells. If you try to use the sum function on nonnumeric cells, you will get an error message.