Follow the steps below to subtract multiple cells in Google Sheets using a formula.
In your Google Sheets, identify the cells you wish to subtract. For example, choose cells B3, B4, and B5, intending to subtract their values from B2.
Click on the cell where you want the result to appear, like C2.
Type the subtraction formula =B2-B3-B4-B5. This formula subtracts the values in B2, B3, B4, and B5 from B1.
After entering the formula, press the Enter key. The result of the subtraction will be displayed in your chosen cell, C2.
Follow the steps below to subtract multiple cells in Google Sheets using the SUM function.
Select a group of cells you want to subtract. For this example, use cells B3, B4, and B5.
Click on an empty cell for the result, such as C2.
Enter the formula =B2-SUM(B3:B5). This formula subtracts the sum of values in B3 to B5 from the value in B2.
Press Enter after typing in the formula. The subtraction result will appear in cell C1.
Follow the steps below to subtract multiple cells in Google Sheets using absolute and relative references.
Choose the cells for subtraction, like B2, B3, and B4 from B1. Plan to use an absolute reference for B1.
In a chosen result cell (e.g., C1), type the formula =$B$1-B2-B3-B4. cells.
Here, $B$1 is an absolute reference to B1, which remains constant if you copy the formula to other cells. The reference to B1 will stay fixed, while the other cell references will adjust relative to their new positions.
Press Enter to see the result. You can then copy this formula to other cells. The reference to B1 will stay fixed, while the other cell references will adjust relative to their new positions.
We hope that you now have a better understanding of how to subtract multiple cells in Google Sheets using different methods. If you enjoyed this article, you might also like our article on how to get rid of dollar signs in Google Sheets or our article on how to track changes in Google Sheets.
Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.