Skip to main content

How to subtract in Excel

Subtracting numbers in Microsoft Excel may take a few more steps than you're used to, but it can be done. In this guide, we'll show you four different ways to subtract in Excel: Within a cell, using numbers from different cells, via the SUM function, and using the status bar. This way, you'll have a different method you can use depending on your subtraction needs or desired level of ease of use. Scroll on to learn how to subtract in Excel.

Difficulty

Easy

Duration

10 minutes

What You Need

  • A PC

  • Microsoft Excel

How to subtract within a cell

Just need to quickly subtract two numbers? You can do that within a single cell in an Excel spreadsheet.

Step 1: In an Excel spreadsheet, click on an empty cell. Then, within that cell, type the following (omit the brackets and spaces):

=[first number] - [second number]

For our example, that would look like: =9-1

Subtracting two numbers within a cell in Excel using a formula.

Step 2: Then hit Enter on your keyboard.

The correct answer to your subtraction math problem should immediately appear and replace the formula you typed in.

In our example, the answer that appeared was 8.

The correct answer that appears after using a formula to subtract two numbers within a cell in Excel.

How to subtract in different cells

If you have numbers located in different cells in your spreadsheet that you want to subtract, you can do so by using cell references and a formula.

Step 1: Choose the numbers you want to subtract and make note of their respective cell references. (A cell reference is a way to denote the location of a given cell in a spreadsheet and the combination of a cell's column number and row number. For example, if one of your numbers is in a cell that is located in column A and row 6, the cell reference for that number would be A6.)

Step 2: Click on a blank cell in your spreadsheet and type in the following formula, omitting the spaces and brackets and filling in your numbers' cell references where appropriate:

=[cell reference for first number] - [cell reference for second number]

In our example, that would look like: =A5-A6

Subtracting two numbers in different cells in Excel using cell references and a formula.

Step 3: Then hit Enter on your keyboard.

The correct answer to this subtraction problem should automatically appear in place of the formula you just typed in.

For our example, since A5 equals 444 and A6 equals 227, the answer that appeared was 217.

The answer that appears after using cell references and a formula to subtract two numbers in different cells in Excel.

How to subtract using the SUM function

While Excel doesn't have a separate subtract function, you can still use the SUM function to subtract numbers.

Step 1: Click on an empty cell. Then type in the following (entering in your own numbers):

=SUM(first number,-second number)

Note: It doesn't matter which number is the negative one, but one of them has to be for the subtraction to occur.

So in our example, since we want to subtract 227 from 444 the formula can look like this:

=SUM(444,-227)

or it can look like this

=SUM(-227, 444)

Using the SUM function to subtract two numbers in Excel.

Step 2: Hit Enter on your keyboard.

The correct answer should immediately replace the formula you typed in.

In our example, the answer would be 217.

How to subtract using the status bar

You don't always have to enter in a formula to subtract numbers in Excel. You can also just use Excel's status bar (located at the bottom of your screen) to your advantage. Just type your numbers into their own individual cells and turn one of them into a negative number. So again, if you wanted to subtract 227 from 444, you would type 444 into one cell and type -227 into the cell next to 444.

Then just select both cells. Now look at the bottom of the screen at the status bar. You'll find your answer next to SUM:.

Using the status bar in Excel to subtract two numbers.

Editors' Recommendations

Anita George
Anita has been a technology reporter since 2013 and currently writes for the Computing section at Digital Trends. She began…
How to factory reset Windows 10 or Windows 11
Windows 10 Home vs. Pro

If you’re dealing with a sluggish or unresponsive computer, you may be close to just giving up. While your misery is understandable, don’t throw in the towel just yet. Before you ditch your computer and spend hundreds, or even thousands, of dollars on a new one, there’s one last trick that can save you time and money: A factory reset.

Follow the steps below to easily and successfully reset your Windows 10 or 11 PC to its clean factory setting. And if you're running into regular slowdowns, check out our guide on how to speed up Windows, too.
First, back up your computer
Before you reset your system, you’ll want to back up important information that you don’t want to lose. This includes documents, photos, music, and movies, but there are other items to back up as well. Make sure that you know all of your saved passwords, export all of your browser bookmarks, and have installation files for all the software you’ll want to reinstall -- or know where to get them.
Also, make sure you back up app-specific data, like custom filters saved in a photo utility, save files from your favorite games, and back up emails if using an offline client.

Read more
How to use ChatGPT to write Excel formulas
A laptop opened to the ChatGPT website.

Not everyone is an Excel spreadsheet expert and you may not always know how to write the formulas you need for a given data set. If you're having trouble figuring out the right formula for your data and computation needs, there's a new option that can help you write up that formula in just a few steps.

That option is ChatGPT, the buzzy, new AI chatbot from artificial intelligence company OpenAI. And among everything else ChatGPT can do, it can also write Excel formulas. In this guide, we'll show you how to use it to get the Excel formulas you need. Let's get started.

Read more
How to deactivate your Instagram account (or delete it)
Instagram login screen.

If you’re getting a bit tired of Instagram, you might want to consider deactivating your account. With Instagram, you have two choices: You can learn how to deactivate your Instagram account, or you can delete it completely. We’ll review both options, so you can decide if you’d rather take a break or cut ties with Instagram forever. Just be cautious, as deleting your Instagram account removes all of your content permanently, and you won’t be able to get it back.

Read more