Show All

Hide All

Let's say you want to find out how many inventory items are not profitable (total inventory – profitable items) or how many employees are approaching retirement age (total employees – employees under 55). There are several ways to subtract numbers.

What do you want to do?

Subtract numbers in a cell

Subtract numbers in a range

Subtract numbers in a cell

To do this task, use the - (minus sign) arithmetic operator.

For example, if you type the following formula in a cell:

10-5

The cell displays the following result:

5

Top of Page

Subtract numbers in a range

To do this task, use the SUM function. Adding a negative number is the same as subtracting.

Example

The example may be easier to understand if you copy it to a blank worksheet.

Function details

SUM

Top of Page