In this article:

Subtract Multiple Cells in Google Sheets (Easiest Way in 2024)

How to Subtract Multiple Cells in Google Sheets using a Formula

Follow the steps below to subtract multiple cells in Google Sheets using a formula. 

1. Identify Cells for Direct Subtraction

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.

google sheets subtract multiple cells

2. Enter Subtraction Formula in Desired Output Cell

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.

3. Press Enter to Display Subtraction Result

After entering the formula, press the Enter key. The result of the subtraction will be displayed in your chosen cell, C2.

How to Subtract Multiple Cells in Google Sheets using the SUM Function 

Follow the steps below to subtract multiple cells in Google Sheets using the SUM function. 

1. Identify the Range of Cells for Grouped Subtraction

Select a group of cells you want to subtract. For this example, use cells B3, B4, and B5.

2. Apply SUM Function for Subtraction in a Cell

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.

3. Confirm the Formula to See the Result

Press Enter after typing in the formula. The subtraction result will appear in cell C1.

How to Subtract Multiple Cells in Google Sheets using Absolute and Relative References 

Follow the steps below to subtract multiple cells in Google Sheets using absolute and relative references. 

1. Determine Cells for Subtraction Using Mixed References

Choose the cells for subtraction, like B2, B3, and B4 from B1. Plan to use an absolute reference for B1.

2. Input Formula with Absolute and Relative References

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.

3. Execute the Formula

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.

Automate everything you track in spreadsheets with Lido
Learn more

Automate manual tasks with Lido

Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.

Trigger
Action
Select trigger
When a cell value in Google Sheets changes
Check Google Sheets for today's date
When a new row is added to Google Sheets
On new Google Form submission
Send me a daily reminder
On new Typeform submission
When a cell value in database changes
Check database for today's date
When a new row is added in database
When a new HubSpot customer is created
Select action
ADDCALENDAREVENT
Creates a one- or multiple-day calendar event with optional attendees
ADDHUBSPOT
Adds an object to Hubspot
ADDSLACKCHANNEL
Create a Slack channel, and optionally add a topic or members
CALLURL
Makes any HTTP request
CREATEGOOGLEDOC
Replaces [@column_name] values in a Google Doc with the corresponding table row's values
CREATEPDF
Replaces [@column_name] values in a Google Doc with the corresponding table row's values, then export it as a PDF
FETCH
Makes any HTTP request and returns the response
INSERTROWS
Inserts given array below defined values in given worksheet
SENDGMAIL
Sends an email using your Google account
SENDOUTLOOK
Sends an email using your Microsoft Outlook account
SENDSLACK
Sends a Slack message
SENDSMS
Sends an SMS message using your Twilio account
UPDATECELL
Updates cells with given values
UPDATEHUBSPOT
Updates a property of a Hubspot object
Trigger is required
Action is required
Get started