How To Use Excel Sum Function

Sum can handle up to 255 individual arguments.

How to use excel sum function. You can add individual values cell references or ranges or a mix of all three. Number2 required argument the second item that we wish to sum. On the home tab click the autosum button on the toolbar. For example to sum the cells that meet the following criteria. What is the excel sum function.

Number1 required argument this is the first item that we wish to sum. Sum function can also do the addition of decimal numbers and fractions. 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. But if you are using sum function as sum cellrange1 cellrange2. Summing with and criteria in excel is easy.

Number3 optional argument this is the third item that we wish to sum. You can also use the sum function in your own formulas to add values. Excel sum function is used to add all numbers stored in the function argument. Sumif supports logical operators and wildcards for partial matching. Instead of using the operator you can use the excel sum function to perform an addition in excel.

These values can be numbers cell references ranges arrays and constants in any combination. If you are using sum formula as sum num1 num2 num n and in place of num you have entered a non numeric content then sum function will throw an name. The sum function uses the following arguments. This displays the sum formula in the cell and highlights the cells to be added. The sum function argument can be a number logical values range cell array or even an excel formula.

The syntax of this function is. To understand the uses of the sum function let s see a few. Sum number1 number2 using sum function is easy and time saving as it doesn t require using operator and manually using cell reference. The excel sum function returns the sum of values supplied. 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.