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

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 bar to create them.

One quick and easy way to add values in Excel is to use AutoSum. Just select an empty cell directly below a column of data, then on the Formula tab, select AutoSum > Sum.

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.

If you need to sum a column or row of numbers, let Excel do the math for you. Select a cell next to the numbers you want to sum, select AutoSum on the Home tab, press Enter, and you're done. When …

To add a new function, position your insertion point after the End Function statement that terminates the last function in the Code window, and begin typing. You can create as many functions as you need in …

One quick and easy way to add values in Excel is to use AutoSum. Just select an empty cell directly below a column of data, then on the Formula tab, select AutoSum > Sum.

If you're new to Excel, or even if you have some experience with it, you can walk through Excel's most common formulas in this tour. With real-world examples and helpful visuals, you'll be able to Sum, …

Create a simple formula in a cell to add, subtract, multiply, or divide numbers by using +, -, *, and /.