Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Add and Subtract in One Cell in Excel (6 Ways)

Adding and subtracting are the two most common mathematical operations in our everyday lives. While working in Excel, you can use a simple formula to add or subtract from the given data in one cell. Thankfully, there are some Excel functions to do that. This tutorial will show you 6 ways how to add and subtract in Excel in one cell.


Download Practice Workbook

Download the following practice workbook. It will help you to realize the topic more clearly.


6 Easy Ways to Add and Subtract in One Cell in Excel

Here we have taken a dataset of students’ marks in the Theory and Practical courses. We will add the marks to get the total marks. We can also subtract the cell value that is also described in the tutorial.

Dataset

Here we have used Microsoft 365 version. You can also use any other version according to your convenience.


1. Using Cell References

You can add and subtract between the cells using the cell numbers. You have to give + (plus) and – (minus) signs after entering a cell in your formula. Here we will demonstrate the steps.

📌 Steps:

  • Firstly, select the cell where you want to calculate. Then select cell F5 and simply add the two cells and then subtract from other cells.
C5+D5E5

Here, C5 and D5 represent the starting cell of Marks in Theory and Marks in Practical respectively. Besides, E5 is the negative mark of each student.

  • Press ENTER.

Using Cell Numbers to add and subtract in one cell in Excel

Fill handle tool

  • Finally, you will find your Total marks by using cell numbers just like the image below.

Read More: How to Add or Subtract Based on Cell Value in Excel (3 Ways)


2. Adding and Subtracting Multiple Cells from One Cell

You can add and subtract from multiple cells by applying the formula. It is an easy task to do so. For example, in one cell (C13) we have entered the total income of the employee and in other cells (D5:D12), we put the expenses. So, in order to find out the total savings of the employees, we have followed the below procedure.

Dataset

📌 Steps:

  • First of all, go to cell E13 and write down the formula below.
=C13-(D5+D6+D7+D8+D9+D10+D11+D12)

Here,

C13= The total Income of the employees

D5:D12= The cell of the individual expenses of the employees.

The syntax C13-(D5+D6+D7+D8+D9+D10+D11+D12) will add all the values of the D column and subtract it from C13.

  • Press ENTER.

Adding and Subtracting Multiple Cells from One Cell in Excel

  • Then, you will get your desired result.

Read More: How to Subtract Sum of Several Cells from Fixed Number in Excel


3. Using SUM Function

The SUM function will add the value you entered in the cell and then you can subtract then by using the minus sign as there is no function for subtraction.

📌 Steps:

  • Initially, go to cell C13 and add the entire range of the column by SUM function.
=SUM(C5:C12).

This function will add the entire range of column C.

  • Press ENTER.

Using SUM Function to add and subtract in one cell in Excel

  • Suppose you want to subtract the expenses from the total income. Simply subtract the summed value from cell C13. Therefore, the formula for the E13 cell will be like the following one.
C13-SUM(D5:D12)

Using SUM function

  • Finally, your result will be just like the one below.


4. Adding and Subtracting Between Two Columns in One Cell

You can add and subtract two columns by applying two SUM functions. It will add two columns and then you can subtract easily.

📌 Steps:

  • Primarily, select cell C13 and add the entire range of columns. Then press ENTER.

Adding and Subtracting Between Two Columns in One Cell in Excel

  • Then, move to cell E13 and write the formula.
=SUM(C5:C12)-SUM(D5:D12)

Here, the SUM function will add the value of columns C and D, and then the minus sign will subtract these two columns.

Adding and Subtracting Between Two Columns in One Cell

  • Finally, you will get your calculated answer.

Read More: How to Add and Subtract Columns in Excel (5 Easy Methods)


5. Adding and Subtracting Between Two Rows in One Cell

Adding two rows is almost the same like add and subtract two columns. For this method, you will have to add or subtract data row-wise. Here, we use a dataset of students’ subject-wise marks and we want to know the difference between two particular students. Follow the steps for row-wise addition and subtraction.

Dataset

📌 Steps:

  • In the beginning, select cell E12 and enter the formula.
=SUM(C5:E5)-SUM(C11:E11)

Here, the SUM function will add the cell’s marks, and then the minus sign will subtract them.

  • Press ENTER.

Adding and Subtracting Between Two Rows in One Cell in Excel

  • Finally, you will get your desired answer.


6. Adding and Subtracting for Percentage in One Cell

Basically, it is easy to subtract two percentage values in Excel. Moreover, the process is similar to subtracting and adding cell numbers formula. Follow the below steps to complete the operation in a handy manner.

📌 Steps:

  • First of all, select cell F5 and enter the formula.
=C5-(D5+E5).
  • Then, press the Enter button on the keyboard. You will get your required answer.
  • Afterward, select the cell and apply the Fill Handle tool to the whole column.

Adding and Subtracting for Percentage in One Cell in Excel

  • Finally, you will find your required values in the following image.


How to Subtract from Previous Cell Using Excel Formula

You can easily subtract one data from another cell. For this, you need not enter any function as there is no function in Excel for subtraction. Simply, a (minus sign) will do the rest.

📌 Steps:

Firstly, select go to cell E5 and enter the formula.

=C5-D5. This formula will simply subtract the value of cell D5 from the value of cell C5.

  • Afterward, press ENTER.

 Subtracting from Previous Cell Using Excel Formula

  • After that, drag down the Fill Handle tool and you will find the subtracted result. It is shown in the image below.

Read More: Adding and Subtracting in Excel in One Formula (4 Easy Ways)


How to Subtract and Dividing in the Same Cell in Excel

Sometimes, you may need to subtract two cells and then divide the answer. Here, we use a dataset of some products whose Quantity and total Amount are given. But we want to divide the Quantity by the Amount to calculate the per unit value. We will also subtract the Discount column to get the Per Unit Value. You should follow the steps to do that.

📌 Steps:

  • First of all, select cell F5 and enter the formula.
=(C5-D5)/E5.

Here,

C5= The gross amount of the products (cables).

D5= Discount given for products.

E5= Quantity for each product.

The formula (C5-D5)/E5 will subtract the value of C5 and the value of D5, and then the output will be divided by the cell E5.

  • Then, press ENTER.

Subtract and Dividing in the Same Cell in Excel

  • Finally, you will get your desired answer just like the one below.


Practice Section

We have provided a practice section on each sheet on the right side for your practice. Please do it by yourself.

Practice Section


Conclusion

That’s all about today’s session. And these are some easy methods on how to add and subtract in excel in one cell.  Please let us know in the comments section if you have any questions or suggestions. For your better understanding, please download the practice sheet. Visit our website Exceldemy, a one-stop Excel solution provider, to find out diverse kinds of excel methods. Thanks for your patience in reading this article.


Related Articles

Fahim Shahriyar Dipto

Fahim Shahriyar Dipto

Hello! Welcome to my Excel blog! I am a big fan of MS Excel. I am learning new and exciting things in Excel and writing the process here. I think this will be helpful for you to get used to Excel. Keep visiting our website for new and updated Excel methods.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo