How To Use Excel Sum Function

Press the enter or return key on your keyboard to see the sum of the selected cells.

How to use excel sum function. These values can be numbers cell references ranges arrays and constants in any combination. Criteria can use a value in another cell as explained below. Number1 required argument this is the first item that we wish to sum. You can also use the sum function in your own formulas to add values. 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 sum function adds values. But if you are using sum function as sum cellrange1 cellrange2. Instead of using the operator you can use the excel sum function to perform an addition in excel. Excel sum function is used to add all numbers stored in the function argument.

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. Summing with and criteria in excel is easy. The excel sum function returns the sum of values supplied. Sum number1 number2 using sum function is easy and time saving as it doesn t require using operator and manually using cell reference.

Sum function can also do the addition of decimal numbers and fractions. On the home tab click the autosum button on the toolbar. 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. Number3 optional argument this is the third item that we wish to sum. For example to sum the cells that meet the following criteria.

Remember when using the sumifs function the first argument is the range to sum followed by two or more range criteria pairs. The sum function argument can be a number logical values range cell array or even an excel formula. The syntax of this function is. Sum can handle up to 255 individual arguments. 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.