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

Get FREE Advanced Excel Exercises with Solutions!

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.


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

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

  • Then drag down the Fill Handle tool for other cells.

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


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.


Similar Readings


3. Using SUM Function

The SUM function will add the value you entered in the cell and then you can subtract them by using the minus sign as there is no dedicated 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. 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 to find the subtracted result. It is shown in the image below.

Read More: Adding and Subtracting in Excel in One Formula


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


Download Practice Workbook

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


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 a better understanding, please download the practice sheet. 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

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo