subtracting cells from other sheets in excel for mac

Subtracting Cells From Other Sheets In Excel Full Using The

However, this time weve already created two formulas in cells A6 and B6.

Then well take a look at other ways to subtract numbers in Google Sheets.

To subtract the number 5 from the number 10 you would do the following.

How to subtract from one cell: Click on cell C2, which is the cell where youll enter the formula Enter the formula A2-B2 or Click on cell C2 Type the equals sign Click on Cell A2 Type the minus sign - Click on Cell B2 Press the return key The answer in cell C2 should be 5.

Youll notice above there were two ways to do the exact same formula.

Subtracting Cells From Other Sheets In Excel Full Using The

The first way is to type the formula in full using the keyboard.

The second way was to use the keyboard and mouse to click on cells you want to include in the formula.

Looking at the instructions above it would appear the first way is quickest, but if the cells you want to add appear on the screen (you dont need to scroll to find the cells).

Then its much quicker to use the second method of clicking on the cells to include in the formula.

Using a range of cells in your formula will make it much quicker than subtracting from each cell individually.

Above you have numbers in cells A2 to A5 and you want to subtract the total of these numbers from cell B2.

How to subtract from a range of cells: Click on cell C2 Enter the formula sum(A2:A5)-B2 This formula has added the numbers in cells A2 to A5, which is 102 and then subtracted the number 54 from cell B2.

Subtracting one range of cells from another range of cells You can also subtract a range of cells from another range of cells.

In the following example, we have a range of numbers in cells A2 to A5 and we want to subtract that total from cells B2 to B5.

How to subtract one range from another range: Click on Cell C2 Enter the formula sum(A2:A5)-sum(B2:B5) This formula is adding the numbers in cells A2 to A5 together and then subtracting the total from the total of cells B2 to B5.

Subtracting one formula from another formula The examples weve looked at so far all work fine, as they bring back the correct result.

However, in practical terms, it would not make much sense using such formulas.

It would most likely be the case that you would regularly need to subtract the numbers in column A with the numbers in column B.

So it would make sense to total these numbers together using a formula.

You can then create a separate formula to do the subtraction.

By doing this you can always see the total of the range of cells.

So lets have a look at these numbers again and see the best way of performing the calculation.

Above we have the same numbers that we used in the previous example.

Subtracting Cells From Other Sheets In Excel For Mac