Excel SUM Function

The SUM Function is an expedient way to add the values within a column or row or even non-adjacent cells. SUM is found within the Functions Tab under Math & Trig, scroll down the menu and select SUM. AutoSum is also located as its own button in the Functions Tab (highlighted).

Excel SUM Function

The third location for the SUM Function is in the Home Tab in the editing box. The fact that Excel has the SUM function in so many locations gives a hint as to how often this function is used.if you want to read cell locking in excel you can read it at https://sgrdimsr.org/lock-cells-excel/

Excel SUM Function

The SUM Function is written as =SUM(number1,number2…) the numbers can be manually entered (4), they can be a cell (A2), or they can be a range (A3:A6) or a combination of all three (4,A2,A3:A6).

SUM

Looking at the above, it show the four ways to easily use the SUM Function at the end of each row to total each expense

  1. Individually – In G2 enter the SUM Function and manually enter all numbers within Row 2, close the parentheses and hit enter.
  2. Cell by Cell – In G3 the SUM Function is entered and each numeric cell is selected in Row 3 separated by commas
  3. Range – G4 shows the Sum of a range of cells. Using a range of cells is best if additional columns will be added because Excel will automatically adjust the Range to reflect any new columns. Individually entering the data and using the cell by cell method will not include new columns in their formulas.
  4. AutoSum – When a range of data is selected as we did in Row 6, the Quick Sum box will appear. Select Totals and click Sum. The first sum within the Quick Sum box shows the
Continue Reading