How to Add (or Subtract) in a Spreadsheet like Excel

Techwalla may earn compensation through affiliate links in this story.
Excel's "AutoSum" can calculate the sum of positive and negative values.

Microsoft Excel 2010 can quickly calculate a row or column of numeric values. Simple operations, such as adding and subtracting, can calculate on the worksheet. The "Home" tab includes an "AutoSum" button in the "Editing" group. This sum function contains a formula that adds the values and inserts the total or sum in an adjacent cell.


Step 1

Open the Excel worksheet.

Video of the Day

Step 2

Enter the values in a row or column.

Step 3

Click a cell to the right of the row of values or click a cell below the column of values. The selected cell displays a black outline.


Step 4

Click the "Home" tab.

Step 5

Click the "AutoSum" button in the "Editing" group. This summation button displays the uppercase Sigma. A formula appears with the range of cells.

Step 6

Press the "Enter" key. The total appears in the selected cell.


Although Excel does not contain a subtract function, you can type a “-“ sign to the left of a value. For example, to add 19, 2, subtract 5 and add 9, type 19, 2,-5, 9. Excel will add a negative value.