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.

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 use the SUM function in Excel to add individual values, cell references, ranges, or a mix of all three.

Let's say that you need to add two different time values together to get a total, or you need to subtract one time value from another to get the total time spent working on a project. As you'll see in the …

How to use the SUMIF function in Excel to add the values in a range that meet criteria that you specify.

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 …

Imagine each column in your table has a letter and each row has a number, like in a Microsoft Excel spreadsheet. For example, to multiply the numbers from the second and third columns in the second …

When your data is in a table, then as you add or remove items from the list, any drop-downs you based on that table will automatically update. You don't need to do anything else.

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.