How to use the SUM function in Excel to add individual values, cell references, ranges, or a mix of all three.

You can use a simple formula to sum numbers in a range (a group of cells), but the SUM function is easier to use when you’re working with more than a few numbers.

Select a cell next to the numbers you want to sum, select AutoSum on the Home tab, press Enter, and you're done. When you select AutoSum, Excel automatically enters a formula (that uses …

To quickly obtain the sum of a range of cells, select the range and see the sum displayed in the lower right-hand side of the Excel window. The Status Bar displays information regarding …

How to create simple formulas in Excel using AutoSum and the SUM function, along with the add, subtract, multiply, or divide values in your worksheet.

Adding and subtracting in Excel is easy; you just have to create a simple formula to do it. Just remember that all formulas in Excel begin with an equal sign (=), and you can use the formula …

Sum every Nth value in a range of values. The following examples show you how to create multi-cell and single-cell array formulas. Where possible, we’ve included examples with some of the …

Sum values based on one or more conditions by using the SUMIFS function in a formula.

Select a cell next to the numbers you want to sum, select AutoSum on the Home tab, press Enter, and you're done. When you select AutoSum, Excel automatically enters a formula (that uses …

Lists all math and trig functions, such as the SUM, SUMIF, SUMIFS, and SUMPRODUCT functions.

Just select an empty cell directly below a column of data, then on the Formula tab, select AutoSum > Sum. Excel will automatically sense the range to be summed.