Here, you can easily subtract two columns in Excel by following row-by-row subtraction. Know How to Quickly Unhide Columns in Excel here. This will automatically subtract them even when you use the SUM function. Here, you can put the negative sign before the numbers in cells C2 to C9. To perform this type of subtraction in MS Excel, you need to put a negative sign before the number itself, inside the cell, and then use the SUM function =-SUM(C1:C9). This is something you might have learned in school, the sum of positive and negative numbers will automatically subtract the numbers. The third method uses the sum of positive and negative numbers to subtract in Excel. This will first sum up the cells C2 to C9 and then subtract the result from cell C1 in Microsoft Excel. Taking the same example used above, the formula can now be written as =C1-SUM(C2:C9). Here, you use the SUM function, to sum the cells that need to be subtracted together from the same cell. This is a single-step method for subtracting in Excel.

It uses the SUM function for subtraction in Excel. It is useful when you have a large number of cells that need to be subtracted from a single cell. This method to subtract values in Excel is slightly different but simplifies the complicated formula in the above method. For example, if you want to subtract C2:C9 from C1 then you can use the formula, =C1-C2-C3-C4-C5-C6-C7-C8-C9. Step 2: As there is no subtract formula in Excel, you can create your own by adding a minus sign in between the cells that you want to subtract. To do this, simply click on the cell and press F2 to edit it. Step 1: Select the cell you want to show your answer in. This is the simplest method to subtract rows and columns in Excel, as it simply uses a minus sign, similar to what you did in elementary school. To read in detail about each method, follow along.

Using the SUM function for subtraction,Ī detailed description of these methods is given below.

The different methods to subtract values in MS Excel we are going to explore as part of this article are: You can check them out below and choose the one that best suits your needs. There are various methods that are used to subtract numbers and other values in Excel. How To Subtract In Excel: Different Methods

Subtracting Rows and Columns in Excel FAQs.

How To Subtract In Excel: Different Methods.

Subtraction formula in excel