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.

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 whatever is …

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 the SUM …

To add up a column or row of numbers in a table, use the Formula command. Select the table cell where you want your result to appear. On the Table Layout tab, select Formula. In the Formula box, check …

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

The SUMIFS function, one of the math and trig functions, adds all of its arguments that meet multiple criteria. For example, you would use SUMIFS to sum the number of retailers in the country who (1) …

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 the SUM …

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.

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