How To Use Excel Sum Function

Sum syntax sum number1 number2 number1 is mandatory argument.

How to use excel sum function. Remember when using the sumifs function the first argument is the range to sum followed by two or more range criteria pairs. Excel sum function is used to add all numbers stored in the function argument. For example to sum the cells that meet the following criteria. Number2 required argument the second item that we wish to sum. Sum function can also do the addition of decimal numbers and fractions.

What is the excel sum function. Sum function in excel is an inbuilt function which is used to sum numerical values present in a range of cells it is a mathematical formula in excel which can be used by typing sum keyword in the cell where we want the sum to be calculated and then we select the range of cells which are to be added. The sum function argument can be a number logical values range cell array or even an excel formula. Number1 required argument this is the first item that we wish to sum. These values can be numbers cell references ranges arrays and constants in any combination.

You can also use the sum function in your own formulas to add values. The first argument is the range to apply criteria to the second argument is the criteria and the last argument is the range containing values to sum. The sum function uses the following arguments. The syntax of this function is. But if you are using sum function as sum cellrange1 cellrange2.

Number3 optional argument this is the third item that we wish to sum. Instead of using the operator you can use the excel sum function to perform an addition in excel. Criteria can use a value in another cell as explained below. On the home tab click the autosum button on the toolbar. Summing with and criteria in excel is easy.

Sum number1 number2 using sum function is easy and time saving as it doesn t require using operator and manually using cell reference. Google and stanford two criteria ranges simply use the sumifs function with the letter s at the end. The sumif function returns the sum of cells in a range that meet a single condition. This displays the sum formula in the cell and highlights the cells to be added. The excel sum function returns the sum of values supplied.