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

You use the SUMIF function to sum the values in a range that meet criteria that you specify. For example, suppose that in a column that contains numbers, you want to sum only the values that are …

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

The easiest way to add a SUM formula to your worksheet is to use the AutoSum Wizard. The AutoSum dialog also lets you select other common functions like: Average, Count numbers, Max, etc.

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 …

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 …

Instead of using a calculator, use Microsoft Excel to do the math! You can enter simple formulas to add, divide, multiply, and subtract two or more numeric values. Or use the AutoSum feature to quickly …

The Sum function is used by default for numeric value fields you place in your PivotTable, but here’s how to choose a different summary function: In the PivotTable, right-click the value field you want to …

Select a cell next to the numbers you want to sum, select AutoSum on the Home tab, press Enter (Windows) or Return (Mac), and that's it! When you select AutoSum, Excel automatically enters a …