So again, if you wanted to subtract 227 from 444, you would type 444 into one cell and type -227 into the cell next to 444. Then just select both cells. Now look at the bottom of the screen at the ...

In our case, we have to sum the data in the cells B2 to B6, hence, the formula is: =B2+B3+B4+B5+B6. Similarly, you can create a formula to subtract data in Excel.

Adding & Subtracting Currency Columns in Microsoft Excel. When you add or subtract... How to Calculate Multiple Cells in Excel. How to Calculate Multiple Cells in Excel.