Step 3: Expand the Formula to Other Cells If you want to subtract column A from column B, the formula would be =B1-A1. In our example, we want to subtract column B from column A, so we will enter the following formula in cell C1: To subtract one column from another in Excel, you use the minus (-) operator. Step 2: Enter the Formula to Subtract Columns in Excel Let’s assume you want to subtract column B from column A and display the result in column C. Step 1: Open the Workbook and Select a Cell to Display the Resultīefore we start subtracting columns, we will open the workbook and select an empty cell where we want to display the result. What if I need to subtract columns located in different workbooks?.What if I receive a #DIV/0! error when trying to subtract columns?.Can I subtract columns based on different criteria?.What if I need to round the result of the subtraction?.Can I subtract more than two columns in Excel?.
Common Errors When Subtracting Columns in Excel.How to Subtract Columns with Multiple Sheets.How to Subtract Columns with Multiple Conditions.Step 3: Expand the Formula to Other Cells.Step 2: Enter the Formula to Subtract Columns in Excel.Step 1: Open the Workbook and Select a Cell to Display the Result.