# Adding and Subtracting in Excel in One Formula (4 Easy Ways)

Option 1 – Performing Calculations from Left to Right

100 – 50 + 30 – 20 + 10

= 10 + 30 +50 – 20

= 40 + 30

= 70

Option 2 – Using Parentheses

100 – 20 + 30 – 50 + 10

= (100 + 10 + 30) – (20 + 50)

= 140 – 70

= 70

We’ll use the following simple dataset.

## Method 1 – Subtracting and Adding Cell References in One Formula

Steps:

• Select cell F5.
• Input an equal sign (=).
• Select cell C5.
• Input a minus sign ().
• Insert the first bracket.
• Select cell D5 and input a plus sign (+).
• Select cell E5 then close the first bracket.
• Here’s the resulting formula:

`=C5-(D5+E5)`

• Press the Enter key on your keyboard to get the result.

• Select the cell and apply the AutoFill tool to the entire column.

• Finally, You will get the following data after completing addition and subtraction.

## Method 2 – Subtracting and Adding Multiple Cells From One Cell

### Case 2.1 – Using the Minus (-) Sign

In one cell (C11) we have entered the total salary expense of the company. In other cells (D4:D9), we put the basic salary in dollars. The total salary includes some allowances also. So, in order to find out the total allowances of the employees, we have followed the below procedure.

Steps:

• Select a cell and write a formula like the following one.

`=C11-(D5+D6+D7+D8+D9)`

• You will get your desired output.

### Case 2.2 – Using the SUM Function

In mathematics, subtracting a number from another number is the same as summing a positive and a negative number. For example, 50 – 20 and 50 + (-20) are actually the same things.

This method is quite similar to the previous one. In our example, we have completed the addition part with the help of the SUM function.

Steps:

• At first, select a cell and write down the following formula.

`=C11-SUM(D5:D9)`

• Press Enter.

## Method 3 – Addition and Subtraction in Two Columns

We want to add the cells of the ranges C5:C9 and D5:D9 and then subtract the sum of the second range from the first one.

Steps:

• Click on any cell outside the data.
• Insert the following formula.

`=SUM(C5:C9)-SUM(D5:D9)`

• Hit Enter.

Read More: How to Add and Subtract Columns in Excel

## Method 4 – Subtraction and Addition for Percentages in Excel

Steps:

• Select a cell and enter a formula like the following one.

`=C5-(D5+E5)`

• Press the Enter button.
• Select the cell and apply the AutoFill tool to the whole column.

• Here are the results.

## Related Articles

<< Go Back to Excel Add and Subtract

Get FREE Advanced Excel Exercises with Solutions!
Kawser Ahmed

Kawser Ahmed is a Microsoft Excel Expert, Udemy Course Instructor, Data Analyst, Finance professional, and Chief Editor of ExcelDemy. He is the founder and CEO of SOFTEKO (a software and content marketing company). He has a B.Sc in Electrical and Electronics Engineering. As a Udemy instructor, he offers 8 acclaimed Excel courses, one selected for Udemy Business. A devoted MS Excel enthusiast, Kawser has contributed over 200 articles and reviewed thousands more. His expertise extends to Data Analysis,... Read Full Bio

1. I am trying to add and subtract across an Excel spreadsheet, ex. add cells B1, D1, F1 and then subtract the sum of cells C1, E1, G1. I thought I had it figured out, but . . . . this is what I came up with, but no go. I may be making this too hard! I can add columns, but can I not add across?
=SUM(B71,D71,F71,H71,J71,L71,N71,P71,R71)-SUM(C71,E71,G71,I71,K71,M71,O71,Q71,S71)

• You may find this formula useful.
`=SUM(FILTER(B2:S2,ISEVEN(COLUMN(B2:S2)))-FILTER(B2:S2,ISODD(COLUMN(B2:S2))))`
Just instead of B2:S2, put your own cell range.
Regards
-ExcelDemy Team

• Hello Queda,
If you want to add and subtract across an Excel spreadsheet, it means if you want to give a cell reference in your formula from another sheet, the formula will look like the following one.

``=SUM(B5,B6,B7,B8,B9,B10)-SUM(Cost!B5,Cost!B6,Cost!B7,Cost!B8,Cost!B9,Cost!B10)``

Without giving the proper sheet and cell reference, the formula won’t work or show an error. If this reply doesn’t give a proper answer to your problem, then send the Excel file to [email protected]. Moreover, you can find the Excel file here.

Advanced Excel Exercises with Solutions PDF