How To Subtract In Google Sheets (In Just 2 Minutes)

Google Sheets allows their user to edit, organize, and analyze different types of formulas in a very easy and simple way. That’s why this article is related to the Google Sheets subtraction formula.

Google Sheets and Microsoft Excel both are different software from each other. But according to the functionality, work, formulation, and calculations, their working is different. But Google sheets are the best tool that provides a shareable link for the users to share the current working sheet with different users with the permission of reading or editing.

Step 1: Data Entry or Adding Amount

First, open the Google Sheet and enter your required amount according to the requirement. An example datasheet we show you in the given Google sheets screenshot.

and then you select the amount that you want to subtract, the things we want to add together are all of these expenses because our income is not expensive, or income is what we are subtracting the expenses from. Again I asked this is just demo data for your understanding of the subtraction formula.

Step 2: Applying Formula Guideline

In the given picture we describe the numbers of the tab. Every Google Sheet tab has a unique number. For example, the Expense 1 value ($2000) tab number is B2. B is the row and column number is 2 as you saw in the screenshot.

For applying the subtraction formula I simply use the “=” sign and Write SUM. After this, a dialogue guideline appears. According to the dialogue box we adding values.

Step 3: Add Tab Numbers For Subtraction in the Total Amount.

Now it’s time to put the value number of the expense (1,2) tabs. In my case, my tab number is B2 and B3. For better understanding, we make a colorful guideline picture. The way of adding value inside the SUM is very simple. Add the tab number like B2 press “,” next tab number B3 and close “)” the bracket. The same thing we did in the screenshot please have a look.

Step 4: Subtract Total Amount in Expenses

Before the SUM and after the equal “=” sign we putting the tab number of the total amount. In my case the monthly total income tab number is B1. So I simply put this and add the subtraction sign “-“.

Step 5: Subtraction Formula Result

After all, this process simply presses enter, and the subtraction result shown in your Google sheet. We perform the sampling procedure and then the final result you can check in this picture.

This formula is a little bit tricky. But we try our best to guide you in a very simple and creative way with examples. During applying this Google Sheet subtraction formula if you face any kind of formula problem share with us.