Add And Subtract Numbers In Excel 2016. Select the range A1A6. The demonstration is given below in the figure.
You can even use the SUM function to create a formula for subtracting numbers in Excel. Adding a negative number is identical to subtracting one number from another. But you get SUM function to add numbers or range of cells.
1 Add and subtract 2 Subtract and multiply 3 Subtract multiply and divide.
We will then review how to preform a combination of the following arithmetic operations. Use the SUM function to add up numbers in a column. The SUM function will add up the values in all the cells between the start cell and the end cell in the shortest. You can subtract the same way you can add by just changing the plus sign to a minus sign in a simple formula.