It’s a beginner-friendly learning kit that includes six hands-on modules about all things Excel. If you’re ready, you can check out the Complete Excel Pro Tips Certification Bundle on Tech Deals. With just a little bit of training, you can be dominating databases and using your skills to progress your career.

Now that you know how to subtract in Excel and you’ve read a little bit about formulas, you’re probably ready to learn more. Related: How to sum a column in Excel What else can you do in Excel? You can choose whichever one you prefer, and they’re all useful for different types of subtraction. There you go, these are four different ways to subtract in Excel. Then you can drag the formula through the entire row, just like the picture below. All it takes is creating a simple =A1-B1 formula. You can also get really fancy and subtract two columns from each other. That means your formula looks like this: =A1-SUM(A2:A5).Ĥ. You can use the SUM formula to add up all of the cells that you want to subtract and then use that in place of typing each cell. Once you’ve mastered the art of subtracting with cells, you can make things a bit easier on yourself. In the example below, you’ll see A1, A2, and A3 placed into the formula in cell A4. Instead of using numbers, you’ll just have to use cell identities instead. You can also subtract entire cells in the same way. If you’re doing math within a single cell, you can use numbers similar to the picture below. As always, you’ll have to start with an equals sign (=) and then add your numbers. The most basic way to subtract is to build your own formula. And please visit our website ExcelDemy to explore more.1. We will try to respond to all the relevant queries asap. And don’t hesitate to ask any questions in the comment section below. You are recommended to download the practice workbook attached with this article and practice all the methods. To sum up, we have discussed 3 methods to subtract from a total in Excel. You will get an Excel sheet like the following screenshot, at the end of the provided Excel file where you can practice all the methods discussed in this article.

Read More: Subtraction Formula in Excel (7 ways) So, you have successfully subtracted the Total Expense from the Total Revenue using the SUM function. ❸ Drag the Fill Handle icon from cell E5 to E12. Here, cell C5 has the Total Revenue amount and cell D5 has the Total Expense amount.

Formula for subtracting in excel