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 currency-formatted numbers, Excel 2013 automatically adopts the currency format for the results.

Armin Rimoldi/Pexels. Using Microsoft Excel to subtract numbers may take a few more steps than you're used to, but it can be done.. In this guide, we'll show you four different ways to subtract in ...

Step 3: In this case, we added an "Expenses" column, and it now shows between Last name and Sales. Mark Coppock/Digital Trends Adding a partial column. Sometimes, you want to add a new column to ...