Using SUM as a Subtraction Formula in Excel - Compute Expert

Using SUM as a Subtraction Formula in Excel


Home >> Excel Tutorials from Compute Expert >> Excel Formulas List >> Using SUM as a Subtraction Formula in Excel





In this tutorial, you will learn how to use SUM as a subtraction formula in excel.

When we work with numbers in excel, we sometimes need to subtract them so we can get the result we want. For this subtraction process, we may want to use a built-in excel formula so we can do it faster.

Unfortunately, there isn’t a formula that excel provides to subtract our numbers. However, we have an alternative formula that we can use for the subtraction purpose, which is SUM.

Want to know how to use SUM as a subtraction formula in excel? Read this tutorial until its last part!

Disclaimer: This post may contain affiliate links from which we earn commission from qualifying purchases/actions at no additional cost for you. Learn more







SUM as a Subtraction Formula?

We use SUM as a subtraction formula? Isn’t SUM the formula we use to sum our numbers in excel?

The primary use of SUM is indeed to sum numbers. However, we can also use it to subtract our numbers in excel.

To do that, we must place a minus symbol ( - ) in the subtractor numbers in our subtraction process. We can place it when we input those numbers into our SUM or in the cells where they are. That way, SUM will sum them as negative numbers, which means they will subtract our positive numbers in our sum process!



The Way to Write It and Its Inputs

The way to write SUM as a subtraction formula is the same as the way we write it to sum our numbers.

= SUM ( number1 , number2 , … )


However, don’t forget to add a minus symbol to the numbers we use as the subtractors. By doing that, we can do our subtraction process smoothly using SUM.



Example of Its Usage and Result

The following will give and explain the example of using SUM as a subtraction formula in excel.

Using SUM as a Subtraction Formula in Excel - Screenshot of the SUM Implementation Example as a Subtraction Formula

In this example, you can see how SUM can run our subtraction process.

Learn Excel Dashboard Course


As we discussed previously, we just need to input all numbers for our subtraction calculation into SUM. Don’t forget to add a minus symbol in front of all the subtractors so SUM can do its job correctly.



Writing Steps

After we have discussed the SUM writing form, inputs, and implementation example, now let’s discuss its writing steps. If you have used SUM to sum your numbers in excel previously, you should be able to master these steps easily!

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

    Using SUM as a Subtraction Formula in Excel - Screenshot of Step 1

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

    Using SUM as a Subtraction Formula in Excel - Screenshot of Step 2

  3. Input the numbers or cell coordinates or cell ranges where you put your numbers. Type comma signs ( , ) between all your inputs.

    Don’t forget the minus symbol on the numbers that become the subtractors. You can add the symbol directly in the SUM formula or the numbers’ cell

    Using SUM as a Subtraction Formula in Excel - Screenshot of Step 3

  4. Type a close bracket sign after you have inputted all your numbers

    Using SUM as a Subtraction Formula in Excel - Screenshot of Step 4

  5. Press Enter
  6. Done!

    Using SUM as a Subtraction Formula in Excel - Screenshot of Step 6




Alternative: Manual Subtraction Formula Writing in Excel

SUM is great for your subtraction process in excel if you have your numbers in a large cell range. You can just input that cell range to SUM without having to input them one by one in your formula writing.

Learn Excel Dashboard Course


If you involve few numbers in your subtraction process, however, it might be better to type a manual subtraction formula. The manual subtraction formula you type should be something like this.

= number_to_subtract - subtractor


Just don’t forget to type a minus symbol in front of your subtractor if it doesn’t have it yet.

Here is the implementation example of the manual subtraction formula writing in excel.

Using SUM as a Subtraction Formula in Excel - Screenshot of the Manual Subtraction Formula Writing Implementation Example

Just use the one which is simpler for your subtraction condition, either SUM or the manual subtraction formula writing!



Exercise

After you have understood how to use SUM as a subtraction formula, now is the time to do an exercise. You should do this exercise so your understanding of the tutorial lessons can become deeper.

Download the exercise file and answer all the questions below. Download the answer key file too if you want to check your answers after finishing the exercise. Or probably when you are confused about how to answer the exercise questions.

Link to the exercise file:
Download here

Questions

Answer the questions in each row in the gray-colored cells using SUM!
  1. What is the subtraction calculation result of the 5 numbers in row no. 1? In this row, we have given a minus symbol to all the subtractors
  2. What is the subtraction calculation result of the 5 numbers in row no. 2? The subtractors are the second and fifth numbers. In this row, we haven’t given a minus symbol to all the subtractors
  3. What is the result if we subtract the no. 2 answer with the no. 1 answer?

Link to the answer key file:
Download here



Additional Note

Using SUM to subtract your numbers in excel might be easier for financial numbers. We usually already give a minus symbol for expenditures in their cells. Thus, there is no need to give minus symbols anymore just for our SUM writing.



Related tutorials you should learn:



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


Excel Calculation

Sum in Excel

Subtraction in Excel

Multiplication in Excel

Division in Excel

Average in Excel



Excel Formula

VLOOKUP Function in Excel

IF Function in Excel

SUM Function in Excel

COUNTIFS Function in Excel

SUMIFS Function in Excel



Excel Tips and Trick

How to Print in Excel

Convert Number to Text in Excel

Excel Worksheet Definition

Excel Range Definition

Excel Shortcuts



Excel Products & Services Recommendation

Best Laptops for Excel

Best Tablets for Excel

Best Keyboards for Excel

Best Mouse for Excel

Best Monitors for Excel



Excel Consultation

About Us

Contact Us

Privacy Policy

Affiliate Disclosure

Terms & Condition



© 2022 Compute Expert