In this tutorial, I am going to share with you **6** easy methods to **subtract columns **in Excel. You can easily apply these methods in any set of data to perform subtraction involving two or more columns. To achieve this task, we will also see some useful features that might come in handy in many other Excel-related tasks.

**Table of Contents**hide

**Download Practice Workbook**

In the dataset, you will find **5** people with their monthly salaries and expenditures. We will try to calculate the monthly savings of each of them using subtraction between columns.

The** intro** datasheet is in its raw form.

The **next 4 sheets** are for methods 1 to 4 respectively.

**Sheet 5 (Method 5)** is used to demonstrate the **subtraction** operation between two given times.

**Sheet 6 (Method 6)** is used to demonstrate the **subtraction** operation between two given dates.

You can download the Excel dataset and practice the mentioned **6** methods:

## 6 Easy Methods to Subtract Columns in Excel

**1. Subtract Numbers Between Two Columns**

To calculate the monthly savings in **Excel**, we need to **subtract** Gross expenditure from the monthly salary. Now do the following to calculate it:

**Steps:**

- First, select cell
**K5**Â to put the calculated value. - Next, type and then hit
`=C5-J5`

**ENTER**. - Consequently, youâ€™ve got the Monthly Savings for Smith.
- Now, place your cursor on the bottom-right corner of cell
**K5**Â and a**Fill Handle**icon will appear. - Finally, drag the
**Fill Handle**icon to the end of the column. Thatâ€™s it.

**2. Subtract Numbers Among Multiple Columns**

Another way of calculating the monthly savings is to **subtract** the **columns Housing, Food, Transport, Health, Clothing, and Utilities** from the **Salary** column.Â Now do the following to calculate it:

**Steps:**

- To begin with, select cell
**K5**Â to put the calculated value. - Now, type and then hit
`=C5-D5-E5-F5-G5-H5-I5`

**ENTER**.Â - Thus, youâ€™ve got the Monthly Savings for Smith.
- Next, place your cursor on the bottom-right corner of cell
**K5**and a**Fill Handle**icon will appear. - Lastly, drag the
**Fill Handle**icon to the end of the column. Thatâ€™s it.

**3. Subtraction Among Multiple Columns Using SUM Function**

Now we will see how to use **the SUM function** to subtract multiple columns in Excel.

**Steps:**

- Â For this method, select cell
**K5**Â to put the calculated value. - After that, type and then hit
`=C5-SUM(D5:I5)`

**ENTER**.Â - Thus, youâ€™ve got the Monthly Savings for Smith.Â
- Now, place your cursor on the bottom-right corner of cell
**K5**and a**Fill Handle**icon will appear. - Then, drag the
**Fill Handle**icon to the end of the column. Thatâ€™s it.

**4. Subtract a Single Number from a Column of Numbers**

In this particular method, we will **subtract** the cell **J5** from the column Salary. Do the following steps:

**Steps:**

- To start with, select cell
**K5**Â to put the calculated value. - Now, type and then hit
`=C5-$J$5`

**ENTER**.

As cell **J5** is fixed, we need the cell to lock up. By placing the **Dollar Sign($)** before J and 5, we can easily **lock up** cell **J5**.

Thus, youâ€™ve got the Monthly Savings for Smith.Â

- Next, place your cursor on the bottom-right corner of cell
**K5**and a**Fill Handle**icon will appear. - Finally, drag the
**Fill Handle**icon to the end of the column. Thatâ€™s it.

**5. Subtract Time Between Two Columns**

To calculate the difference between two given times, you need to subtract the **Ending Time** from the **Starting Time**. For this follow the below steps.

**Steps:**

- Again, select cell
**F5**to put the calculated value. - Now, type and then hit
`=E5-D5`

**ENTER**. - Thus, youâ€™ve calculated the work hour for 1st January 2020.
- After that, place your cursor on the bottom-right corner of cell
**F5**and a**Fill Handle**icon will appear. - At last, drag the
**Fill Handle**icon to the end of the column. Thatâ€™s it.

**6. Subtract Dates Between Two Columns**

To calculate the number of days between specific dates, we need to **subtract** the Ending Date from the Starting Date. Now go through the following steps:Â

**Steps:**

- Select cell
**E5**Â to put the calculated value. - Type and then hit
`=D5-C5`

**ENTER**. - Place your cursor on the bottom-right corner of cell
**E5**and a**Fill Handle**icon will appear. - Drag the
**Fill Handle**icon to the end of the column. Thatâ€™s it.

## Conclusion

In this article, we have demonstrated six different methods that can be used to **subtract columns** in Excel. As thereâ€™s no default function to perform subtraction among columns in Excel, one can follow these easy-peasy methods as per oneâ€™s requirement.