# How to Subtract in Google Sheets Subtraction is one of the four basic operations of mathematics. In Google Sheets, you can use subtraction alone, or in combination with other functions to create complex formulas. There is no special function for subtraction in Google Sheets. To subtract two numbers, you can simply use the minus sign (-).

In addition to subtracting numbers from each other, you can also subtract cell values ​​by referring to them in the formula bar. Moreover, you can subtract a group of numbers sequentially and even subtract matrices from each other. You can accomplish all of these tasks by using the minus sign (-) in Google Sheets.

## You can also subtract multiple numbers in a single formula. There are many ways to do this, but we’ll look at two of the easiest methods: Sequential Subtraction and the SUM function. We will deploy both methods on an extension of the previous example. Here we have a spreadsheet with the number of initial volunteers, as well as the volunteers who quit each month.The goal is to calculate the number of current volunteers by subtracting the number of resigning volunteers from the initial number of volunteers.

### Sequential subtraction

In this method, we start from the cell we want to subtract from, then add the cells we want to subtract to that cell with a minus sign () between each cell reference.

1. Select the cell in which you want to display the final result. This will be the cell B8 for the current example.
2. In the formula bar, enter the formula below:
` `=B1-B2-B3-B4-B5-B6-B7` `
3. Press on Come in. You can now see the number of current volunteers.

This formula allows us to subtract B2 of B1then subtract B3 from the remainder of the previous subtraction. It will continue until B7 is subtracted from the remainder of all previous subtractions, giving us the number of current volunteers.

### Subtraction with the SUM function

While sequential subtraction gets the job done, entering cell references one by one is still a chore. After all, isn’t Google Sheets all about making things easier?

This is where the SUM function comes in. This function allows you to sum numbers and cells in Google Sheets.

` `=SUM(value1, value2, value3, ...)` `

The values ​​you enter can be numbers or cells containing numbers. SUM only works with numeric values.

To subtract multiple cells in Google Sheets, you can sum all the subtractions using the SUM function and then subtract them from the original number. In this method, we will use the SUM function to obtain the results of the previous example without having to consult the cells one by one:

1. Select the cell in which you want to display the result of the subtraction. As before, we will use the cell B8.
2. In the formula bar, enter the formula below:
` `=B1-SUM(B2:B7)` `
3. Press on Come in.

This formula uses the SUM function to add up all the resigned volunteers (B2 at B7) together, then it subtracts the total of quitting volunteers from the original volunteers. The resulting number will be the number of current volunteers.