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
Click the cell for the result.
-
2
Enter =A1-B1 (swap cells for your numbers).
-
3
Or enter =MINUS(A1, B1).
-
4
Fill down for more rows, or use ARRAYFORMULA for the column.
Related tutorials
These videos might help you go deeper on this topic.
Bjarne Asks: Can I show the total number of rows minus the header row?
Better Sheets on YouTube
Watch matching videos from youtube.com/bettersheets.
Terms and formulas behind this
Want the full definition or how a formula works? Start here.
Wrap text
Wrap text displays cell content on multiple lines within the same cell instead of spilling into neighbors. Format > T...
Open →ARRAYFORMULA
ARRAYFORMULA tells Google Sheets to treat a formula as an array operation so one expression fills many cells at once....
Open →cell formatting
Cell formatting controls how values display without necessarily changing the stored value underneath. Currency, perce...
Open →Google Sheets formulas
A formula is an instruction in a cell that calculates a result from other cells, ranges, or built-in functions. Every...
Open →Google Sheets formula syntax
Every formula starts with = followed by a function name and arguments in parentheses. Ranges use A1 notation, text si...
Open →ARRAYFORMULA()
Google Sheets ARRAYFORMULA() function guide
Open →COLUMN()
Google Sheets COLUMN() function guide
Open →DAY()
Google Sheets DAY() function guide
Open →DURATION()
Google Sheets DURATION() function guide
Open →MINUS()
Google Sheets MINUS() function guide
Open →ROWS()
Google Sheets ROWS() function guide
Open →SIGN()
Google Sheets SIGN() function guide
Open →Related questions
How to subtract in Google Sheets formula
Use a minus formula such as =A1-B1, or =MINUS(A1, B1). Fill down for a column. Subtracting dates returns day counts; format duration results appropriately.
Get the answer →How to subtract in google spreadsheet
Use a minus formula such as =A1-B1, or =MINUS(A1, B1). Fill down for a column. Subtracting dates returns day counts; format duration results appropriately.
Get the answer →What is subtract in Google Sheets
Use a minus formula such as =A1-B1, or =MINUS(A1, B1). Fill down for a column. Subtracting dates returns day counts; format duration results appropriately.
Get the answer →How to subtract on google sheet
Use a minus formula such as =A1-B1, or =MINUS(A1, B1). Fill down for a column. Subtracting dates returns day counts; format duration results appropriately.
Get the answer →How to subtract in google sheet
Use a minus formula such as =A1-B1, or =MINUS(A1, B1). Fill down for a column. Subtracting dates returns day counts; format duration results appropriately.
Get the answer →How to sort a column in Google Sheets by number
Select your data, then use Data → Sort sheet or Data → Sort range. Pick the column and direction. Advanced range sorting options let you add secondary keys. Sorting changes the sheet in place; =SORT(...) builds a sorted spill range elsewhere.
Get the answer →Need more than a quick answer?
Membership unlocks 636+ tutorials, unlimited generators, and every template.