# AutoSum (and Other Common Auto-Formulas)

AutoSum (and Other Common Auto-Formulas)

# AutoSum (and Other Common Auto-Formulas)

Some formulas can be entered simply by clicking a button in Excel. Excel will even guess which data the formula applies to, meaning that if your spreadsheet is properly laid out, you don't have to select the cells.

### AutoSum

To quickly sum a row or column of data:

1. Select the cell to the right or at the bottom of a set of numbers:
2. On the HOME tab, in the Editing group, click the AutoSum command:
3. Note that Excel guesses the data you wish to sum and gives you the option to edit the formula if you wish:
4. Press Enter.

### Count Numbers

To quickly count the number of cells in a row or column that have data:

1. Select the cell to the right or at the bottom of a set of numbers:
2. On the HOME tab, in the Editing group, click the drop-down arrow to the right of the AutoSum command:
3. Select Count Numbers:
4. Note that Excel guesses the cells in which you wish to count numbers and gives you the option to edit the formula if you wish:
5. Press Enter.

### Average

To quickly average the numbers in a row or column:

1. Select the cell to the right or at the bottom of a set of numbers:
2. On the HOME tab, in the Editing group, click the drop-down arrow to the right of the AutoSum command:
3. Select Average:
4. Note that Excel guesses the cells in which the data you wish to average lies and gives you the option to edit the formula if you wish:
5. Press Enter.

### Min

To quickly find the minimum number in a row or column:

1. Select the cell to the right or at the bottom of a set of numbers:
2. On the HOME tab, in the Editing group, click the drop-down arrow to the right of the AutoSum command:
3. Select Min:
4. Note that Excel guesses the cells in which you wish to find the minimum number and gives you the option to edit the formula if you wish:
5. Press Enter.

### Max

To quickly find the maximum number in a row or column:

1. Select the cell to the right or at the bottom of a set of numbers:
2. On the HOME tab, in the Editing group, click the drop-down arrow to the right of the AutoSum command:
3. Select Max:
4. Note that Excel guesses the cells in which you wish to find the maximum number and gives you the option to edit the formula if you wish:
5. Press Enter.