Updated: November 18, 2026

If you need a Google Sheets formula to subtract, the simplest answer is to use the minus sign inside a cell formula. You can subtract one number from another, subtract values in different cells, or subtract entire ranges with a few basic patterns. Once you understand the syntax, subtraction in Google Sheets becomes quick, reliable, and easy to copy down a column.

The basic subtraction formula in Google Sheets

The core subtraction formula in Google Sheets uses the minus operator, not a special subtraction function. If you want to subtract 5 from 12, enter =12-5 in a cell. If you want to subtract one cell from another, use references such as =A1-B1. That is the standard subtraction formula in Google Sheets, and it works for numbers, dates, and times.

Subtract two cells

To subtract two cells, click the result cell and type a formula like =A2-B2. This is the most common Google Sheets formula for subtracting cells. It reads the value in A2, subtracts the value in B2, and returns the difference. If A2 contains 50 and B2 contains 18, the result is 32.

This same pattern answers queries like Google Sheets formula subtract two cells, Google Sheets formula to subtract cells, and Google Sheets formula for subtraction. The minus sign does the work, so there is no separate function named SUBTRACT for basic arithmetic.

Subtract numbers directly

If you already know the numbers, type them directly into the formula bar. For example, =100-27 returns 73. This is the cleanest Google Sheets subtract formula for quick calculations. You can chain more numbers together too, such as =100-27-8, which gives 65.

How to subtract multiple cells

To subtract multiple cells, continue the formula with more minus signs. Google Sheets does not need a special multi-subtraction function for this. If you want to subtract A2, B2, and C2 from D2, use =D2-A2-B2-C2. The calculation happens from left to right, so the first value becomes the starting point.

Subtract a list of values in one row

If your values are spread across a row, use a simple chain like =B2-C2-D2-E2. This is the direct Google Sheets formula for subtract multiple cells. It works best when one number is the total and the other cells are deductions, such as expenses, units sold, or adjustments.

  1. Click the cell where you want the result.
  2. Type an equals sign.
  3. Enter the first cell reference.
  4. Add a minus sign, then the next cell reference.
  5. Repeat for any additional cells.
  6. Press Enter.

Subtract a total from a sum of cells

Sometimes you want to subtract one cell from several added cells. In that case, combine addition and subtraction in one formula, such as =A1+B1-C1 or =SUM(A1:B1)-C1. This is the practical Google Sheets add and subtract formula pattern when the calculation mixes both operations. Use SUM when you want the formula to stay readable across a wider range.

Subtract whole columns or copied rows

For column-by-column subtraction, write the formula in the first result cell and copy it down. If column A contains starting values and column B contains deductions, enter =A2-B2 in C2, then fill down. Each row will adjust automatically to use its own cells. This is the standard Google Sheets subtract columns workflow.

Use subtraction across many rows

If you need the same subtraction in every row, enter the formula once and drag the fill handle down. For example, C2 can contain =A2-B2, C3 becomes =A3-B3, and so on. This is the fastest Google Sheets formula subtract cells method when working with a table of repeated calculations.

If you want to subtract an entire fixed value from each row, lock that cell with dollar signs. For example, =A2-$E$1 always subtracts E1 from every row when copied down. Absolute references keep the deduction cell fixed while the row changes.

Subtract one column from another

When one column is a total and the other is an adjustment column, use a third column for the result. For example, =B2-C2 in D2 subtracts column C from column B. This is the clearest way to answer how to subtract cells in Google Sheets when the data is arranged vertically. It also keeps your source data untouched.

How to use subtraction with addition, dates, and times

Google Sheets handles subtraction alongside other basic operators, so you can build one formula for a full calculation. If you want to know how to add and subtract in the same cell, use a combined formula such as =A1+B1-C1. The order is straightforward, and the result updates when any referenced cell changes.

Subtract dates

Date subtraction returns the number of days between two dates. If A2 contains 2026-01-15 and B2 contains 2026-01-10, =A2-B2 returns 5. This is useful for tracking deadlines, project timelines, and age in days. If the result displays as a date, change the cell format to Number.

Subtract times

You can subtract time values in the same way. If A2 is 3:00 PM and B2 is 1:30 PM, =A2-B2 returns 1:30. If the result shows strangely, format the result cell as Duration or Time. The subtraction formula in Google Sheets is the same, but the cell formatting controls how the answer appears.

Is there a Google Sheets subtraction function?

There is no built-in SUBTRACT function for basic arithmetic in Google Sheets. The Google Sheets subtraction function people search for is really the minus operator inside a formula. So the correct answer to Google Sheets function subtract and Google Sheets function for subtraction is to use =A1-B1 or another formula with minus signs.

What about a code for subtraction?

If you search for Google Sheets code for subtraction, the practical answer is still the same formula syntax. Google Sheets formulas are the code. Use =A1-B1 for two cells, =A1-B1-C1 for multiple cells, and =SUM(A1:A5)-B1 when you need a total minus one value. There is no separate programming step for basic subtraction.

When SUM helps more than a long chain

For a long row of numbers, SUM keeps the formula cleaner. Instead of writing =A1-B1-C1-D1-E1, you can use =A1-SUM(B1:E1). That is the best Google Sheets subtract formula when one cell needs to lose several values at once. It is easier to read and simpler to edit later.

Common subtraction mistakes and fixes

The most common mistake is typing text instead of numbers. If a cell contains currency symbols entered as plain text, the formula can fail or return an error. Make sure the values are numeric cells, not text strings. Another common issue is forgetting the equals sign. Every formula in Google Sheets starts with =.

Fix errors from blank cells or text

If one referenced cell is blank, subtraction treats it as zero in many cases, which can change the result in a way you did not expect. If a cell contains words, the subtraction formula will not work. Clean the data first, or use a helper column to convert values into numbers. That is the simplest way to keep Google Sheets subtraction formula results accurate.

Choose the right format for the result

Number formatting matters after the formula works. For plain arithmetic, keep the result cell set to Number or Currency. For date differences, use Number. For time differences, use Duration or Time. This prevents confusion when the formula is correct but the display looks wrong.

Frequently Asked Questions

How do you subtract in Google Sheets formula?

Type an equals sign, then use the minus operator between values or cell references. For example, =A1-B1 subtracts the value in B1 from A1. That is the standard Google Sheets how to subtract formula.

What is the Google Sheets formula for subtracting cells?

Use =A1-B1 for two cells, or extend it to =A1-B1-C1 for more than two cells. This is the direct Google Sheets formula for subtracting cells and the simplest subtraction formula in Google Sheets.

How do I subtract multiple cells in Google Sheets?

Chain the cells with minus signs, or subtract a range with SUM. For example, =A1-B1-C1 subtracts multiple cells one by one, while =A1-SUM(B1:D1) subtracts a whole group at once.

Is there a Google Sheets subtract function?

No. Google Sheets uses the minus sign for subtraction, not a dedicated subtract function. The search terms Google Sheets subtract function and Google Sheets function for subtraction both point to the same formula method, such as =A1-B1.

How do I subtract columns in Google Sheets?

Place the subtraction formula in a result column, such as =A2-B2, then copy it down. Each row will subtract the cells in that row. This is the cleanest way to handle Google Sheets subtract columns across a table.

How do I add and subtract in one formula?

Mix plus and minus signs in the same formula, such as =A1+B1-C1. If you are combining many cells, use SUM for clarity, such as =SUM(A1:B1)-C1.