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 ...

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.

Open Microsoft Excel. Enter a list of values in column A. As an example, you might enter item costs as "$10.95," "$9.99" and "$29.99" in cells A1 through A3. Enter your second list of values in ...

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.