How to add and subtract multiple cells in excel

There's no SUBTRACT function in Excel. However, there are many ways to subtract numbers in Excel. Are you ready to improve your Excel skills?

1.

For example, the formula below subtracts numbers in a cell.

Excel subtraction formula for column

Simply use the minus sign (-) as the subtraction operator. Don't forget, always start a formula with an equal sign (=).

2. The formula below subtracts the value in cell A2 and the value in cell A3 from the value in cell A1.

3.

As you can imagine, this formula can get quite long. Simply use the SUM function to shorten your formula.

How to subtract multiple cells in excel

For example, the formula below subtracts the values in the range A2:A9 from the value in cell A1.

Take a look at the screenshot below. To subtract the numbers in column B from the numbers in column A, execute the following steps.

4a. First, subtract the value in cell B1 from the value in cell A1.

4b.

How to subtract two columns in excel

Next, select cell C1, click on the lower right corner of cell C1 and drag it down to cell C6.

Take a look at the screenshot below. To subtract a number from a range of cells, execute the following steps.

5a.

First,

how to deduct sum in excel

how to subtract two sums in excel