The arguments can contain:
A maximum of 30 numbers can be added by the function.
Below are listed the steps used to enter the SUM function into cellA7as shown below.
SelectA7to make it theactive cell(the location where the results of the function will be displayed).
Towfiqu Photography / Getty Images
Press theSUMbutton next to the input line.
TheSUMfunction should be entered into the active cell the function should automatically enter the cell referenceA6as the number argument.
PressEnterto complete the function.
Select cellA7to make it the active cell the location where the results of the function will be displayed.
Select theCategorydrop-down list and selectMathematicalto see the list of math functions.
UnderFunction, selectSUMfrom the list of functions.
Selectnumber 1in the dialog box, if necessary.
Select cellA1in the worksheet to enter that cell reference into the dialog box.
Selectnumber 2in the dialog box.
Select cellA3in the worksheet to enter that cell reference.
Selectnumber 3in the dialog box.
Select cellA6in the worksheet to enter that cell reference.
Selectnumber 4in the dialog box.
Highlight cellsB2andB3in the worksheet to enter this range.
SelectOKto terminate the dialog box and return to the worksheet.
The number695should appear in cellA7 as this is the sum of the numbers located in cellsA1toB3.
When you select cellA7.
Using the dialog box in this situation makes it easier to add the individual cells to the function.
Not only is pointing easier, it also helps to reduce errors in formulas due to incorrect cell references.
