So, make all the numbers you want to subtract negative (for this, simply type a minus sign before a number), and then use the SUM function to add up the negative numbers: To make your formula more compact, add up the subtrahends (B2:B6) using the SUM function, and then subtract the sum from the minuend (B1):Īs you may remember from a math course, subtracting a negative number is the same as adding it. Simply type several cell references separated by a minus sign like we did when subtracting multiple numbers.įor example, to subtract cells B2:B6 from B1, construct a formula in this way: To subtract multiple cells from the same cell, you can use any of the following methods. How to subtract multiple cells from one cell in Excel Press the Enter key to complete your formula.Īnd you will have a result similar to this:.Click on the cell containing a subtrahend (a number to be subtracted) to add its reference to the formula (B2). Its reference will be added to the formula automatically (A2).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |