# 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, you can also subtract cell values ​​by referencing them in the formula bar. Also, you can sequentially subtract a group of numbers and even subtract matrices. You can perform 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 implement both methods in continuation of the previous example. Here we have a spreadsheet with the number of initial volunteers, as well as the volunteers who resign each month.The goal is to calculate the number of current volunteers by subtracting the number of retiring volunteers from the original number of volunteers.

### Sequential subtraction

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

1. Select the cell where you want to display the final result. This will be the cell B8 for the current example.
2. Enter the formula below in the formula bar:
` `=B1-B2-B3-B4-B5-B6-B7` `
3. pressure 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 continues until B7 is subtracted from the remainder of all previous subtractions, giving us the number of present volunteers.

### Subtraction with the SUM function

Although 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 into play. This feature allows you to sum numbers and cells in Google Sheets.

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

The values ​​you enter can be numbers or cells that contain 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 where you want to display the result of the subtraction. As before, we will use the cell B8.
2. Enter the formula below in the formula bar:
` `=B1-SUM(B2:B7)` `
3. pressure Come in.

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