To subtract a percentage value, such as 50%, from a number, you’ll need to enter the value in a cell with percentage format. Subtracting Percentage Values from Figures So, that’s deducting the C7: C9 cell range from the B7:B9 cell range total, which is otherwise 175 – 75. Press Enter to add the function to the spreadsheet, which will return the value 100 in C11. Select C11 as the cell to add the formula to, and then input ‘ =SUM(B7:B9)-SUM(C7:C9)‘ in the function bar.Now you can deduct the total of the C7:C9 cell range from the B7:B9 range entered earlier. For example, enter the numbers ‘ 25,’ ‘ 15‘ and ‘ 35‘ in cells C7:C9.Instead, add the cell range references to a formula and subtract them. You can also subtract cell range totals without entering SUM functions in the spreadsheet first. Subtract Two or More Total Cell Range Values That effectively deducts the total of cells B7:B9 from 200 in cell B11. Cell B12 will then return the value of 25 as shown directly below. Select cell B12, click in the fx bar and input ‘ =B11-SUM(B7:B9)‘ in the formula bar. For example, enter the values ‘ 45,’ ‘ 55‘ and ‘ 75‘ in the cells B7 to B9.However, you can also subtract a cell range total by including SUM within a formula. What if you need to subtract a column total for a group of cells from a single value? One way to do that would be to enter a SUM function in a cell that adds the range together, and then subtract that total with a separate formula.

Subtract a Cell Range Total from a Single Value

Now, the cells directly below D3 also subtract 5 from the numbers in C4 and C5.

Copy the formula in D3 to the other cells below it by selecting D3, clicking the bottom right corner of the cell and dragging it over the ones below as shown below. D3 will now subtract 5 from 25 in cell C3.

Then, select cell D3, enter the formula ‘ =C3-5‘ in the function bar and press the Return key.

For example, enter the values ‘ 25,’ ‘ 35‘ and ‘ 55‘ in cells C3:C5.

If you need to subtract a single value from each number within a cell range, you can copy the formula to other cells. Subtract One Number from Each Value within a Cell Range B5 will now return the value 200 as shown below. Input the formula ‘ =B3-B4‘ and press the Return key.

Now, select cell B5 and click in the fx bar to enter a formula.

For example, enter the values ‘ 345‘ and ‘ 145‘ in cells B3 and B4 in a blank Excel spreadsheet as in the snapshot below.

To subtract cell values, you’ll need to include their row and column references in the formula instead. However, most Excel users will need to subtract numbers entered in spreadsheet columns and rows.

The formula’s cell will return the value 20. For example, input ‘ =25-5‘ in the function bar and press Enter. Then click in the Excel function bar and input ‘ =‘ followed by the values you need to deduct.First, select a cell to add the formula to.

Excel subtraction formula not working