How to subtract in Google Sheets

Type a formula with a minus sign, for example =A1-B1, and press Enter. You can also use =MINUS(A1, B1). Subtract dates to get day counts, or subtract times for durations (format the result as a number or duration). For a whole column, put the formula in the first data row and fill down, or wrap it in ARRAYFORMULA.

Steps

  1. 1

    Click the cell for the result.

  2. 2

    Enter =A1-B1 (swap cells for your numbers).

  3. 3

    Or enter =MINUS(A1, B1).

  4. 4

    Fill down for more rows, or use ARRAYFORMULA for the column.

Related tutorials

These videos might help you go deeper on this topic.

Watch more tutorials
Bjarne Asks: Can I show the total number of rows minus the header row?

Bjarne Asks: Can I show the total number of rows minus the header row?

find out how to show the total number of data rows available in a sheet.

Better Sheets on YouTube

Watch matching videos from youtube.com/bettersheets.

Search channel

Terms and formulas behind this

Want the full definition or how a formula works? Start here.

Related questions

Ads keep the free stuff free. Members browse ad-free — log in or see pricing.
Big Year 2027 calendar: the whole year on one Google Sheet

Free 2027 calendar.Plan all of 2027 on one Google Sheet, free.

Copy it to your Google Drive.

Free. No password, no card. The sheet link shows up right here.