First, copy the cell value that you need to subtract from the other cells.

Below are simple steps to follow to understand how to add and subtract multiple cells in Excel with the Paste Special option.

You will get the results in the same cells after subtraction.

In this example, you will notice the value in cell B2 from the values in cell A2 to A8 is subtracted. The Paste Special feature is a great option when you need to subtract one value from multiple cells. Other than a formula, Excel has many other features that let you perform a task. That’s it! How to Add and Subtract Multiple Cells in Excel without a Formula? At the end, you will notice it subtracts the second output from the first outcome. Using this formula will first add the amounts in Column C and then in Column D. And then you have to subtract the sum of another range from 1st range.

Suppose you need to add a cell range from C5:C10 and D5:D10. The parenthesis always indicates the number values are negative, therefore remember that when you are trying to add such amounts in a single SUM function, it means you are adding positive values and subtracting the negative values simultaneously.Īdd and Subtract Two Columns in One Formula with the SUM Function You can see the March savings are not opened in the first bracket.In cell E11, put the following formula:.Here you will see the use of the SUM function to find the net saving figure. That’s it! Add and Subtract in One Column with the SUM Functionĭo you know subtracting a value from another value is the same thing as adding a positive and a negative value? In cell E11 put the following formula and press ENTER.In this example, you will see a subtraction of all the expenses from half-yearly income to find the amount of net savings. You have to add and subtract the income and expenses now. Suppose your dataset contains 3 separate columns of Month, Income, and Expenses. Without further discussion, let’s get straight into it: Add Multiple Cells and Subtract from One Cell In that case, you will find this post useful because today you will get to know how you can add or subtract multiple cells at the same time in Excel. Sometimes, you may find it difficult to understand how to add and subtract multiple cells in Excel. Addition and subtraction both are the most used operations in math and when it comes to Excel, you will also find them helpful in performing many other operations.

Subtraction in excel formula