How to Subtract in Google Sheets: A Step-by-Step Guide

by

Google Sheets makes it easy to perform calculations, including subtraction. Whether you’re tracking expenses, calculating profits, managing inventory, or working with budgets, knowing how to subtract values in Google Sheets can save time and improve accuracy.

This guide explains several ways to subtract numbers in Google Sheets, from basic formulas to more advanced techniques.

Why Use Subtraction in Google Sheets?

Subtraction is useful for many everyday spreadsheet tasks, including:

  • Calculating profits and losses
  • Tracking expenses
  • Comparing sales figures
  • Managing inventory levels
  • Determining budget differences
  • Monitoring project costs

By using formulas, Google Sheets automatically updates results whenever your data changes.

Understanding the Subtraction Formula

Unlike some spreadsheet functions, Google Sheets does not have a dedicated SUBTRACT function.

Instead, subtraction is performed using the minus sign (-).

Basic Formula:

=A1-B1

This formula subtracts the value in cell B1 from the value in cell A1.

Step 1: Open Your Google Sheet

Start by opening the spreadsheet where you want to perform the calculation.

To do this:

  1. Open Google Sheets.
  2. Create a new spreadsheet or open an existing one.
  3. Enter your data into separate cells.

Example:

A B
100 40

Step 2: Select the Cell for the Result

Click the cell where you want the subtraction result to appear.

For example:

C1

This is where the answer will be displayed.

Step 3: Enter the Subtraction Formula

Type the formula:

=A1-B1

Then press Enter.

Result:

100 - 40 = 60

The answer will appear instantly.

Step 4: Subtract Multiple Rows

If you have many rows of data:

Sales Expenses
500 300
750 400
900 600
See also  How to Send Everything as a Text Message on an iPhone 14: A Guide

Enter this formula in the first result cell:

=A2-B2

Press Enter.

To apply it to additional rows:

  1. Select the cell containing the formula.
  2. Drag the fill handle downward.

Google Sheets automatically adjusts the references for each row.

Step 5: Subtract a Fixed Value from Multiple Cells

Suppose you want to subtract the same value from several numbers.

Example:

A B
100
200
300

Place the value to subtract in cell D1:

20

Use:

=A1-$D$1

The dollar signs create an absolute reference, ensuring the formula always subtracts D1.

Step 6: Subtract Dates in Google Sheets

Google Sheets can calculate the difference between dates.

Example:

Start Date End Date
01/01/2026 01/15/2026

Formula:

=B1-A1

Result:

14

The answer represents the number of days between the dates.

Step 7: Subtract Using Numbers Directly

You can subtract numbers without cell references.

Example:

=50-15

Result:

35

This is useful for quick calculations.

Step 8: Subtract Multiple Values

You can subtract several numbers in one formula.

Example:

=500-100-50-25

Result:

325

Google Sheets processes the calculations from left to right.

Step 9: Calculate Profit or Loss

One of the most common uses of subtraction is profit calculation.

Example:

Revenue Expenses
1500 900

Formula:

=A2-B2

Result:

600

This shows your profit after expenses.

Step 10: Use Subtraction with Other Functions

You can combine subtraction with formulas.

Example:

=SUM(A1:A5)-SUM(B1:B5)

This subtracts the total of one range from another.

Common Errors and Fixes

#VALUE! Error

Cause:
One of the cells contains text instead of a number.

Solution:
Ensure all referenced cells contain numeric values.

Incorrect Results

Cause:
Wrong cell references.

See also  How to Recover Old Messages on iPhone: A Step-by-Step Guide

Solution:
Double-check the formula and referenced cells.

Formula Displays Instead of Calculating

Cause:
The cell is formatted as plain text.

Solution:
Change the cell format to Automatic or Number and re-enter the formula.

Useful Subtraction Examples

Budget Tracking

=Income-Expenses

Inventory Management

=Stock Received-Stock Sold

Sales Analysis

=Current Month Sales-Previous Month Sales

Expense Comparison

=Budgeted Cost-Actual Cost

Tips for Working with Subtraction Formulas

Use Cell References

Referencing cells instead of typing numbers makes formulas dynamic and easier to update.

Label Your Data

Clear headings make formulas easier to understand.

Check Formatting

Ensure cells are formatted as numbers when performing calculations.

Use Absolute References When Needed

Add dollar signs ($) when a reference should remain fixed.

Frequently Asked Questions

Is there a SUBTRACT function in Google Sheets?

No. Google Sheets uses the minus sign (-) for subtraction.

Can I subtract dates?

Yes. Subtracting one date from another returns the number of days between them.

Can I subtract entire columns?

Yes. Use formulas and drag them down to calculate multiple rows.

How do I subtract percentages?

Use a formula such as:

=A1-(A1*10%)

This subtracts 10% from the value in A1.

Benefits of Using Subtraction in Google Sheets

  • Fast calculations
  • Automatic updates
  • Improved accuracy
  • Better financial tracking
  • Simplified data analysis

Conclusion

Subtracting in Google Sheets is simple and highly useful for managing budgets, analyzing data, tracking expenses, and performing everyday calculations. By using the minus operator (-), you can quickly subtract individual values, multiple numbers, dates, or entire columns.

Once you understand the basics, you can combine subtraction with other formulas and functions to build powerful spreadsheets that update automatically as your data changes.

Leave a Comment