What is the AUTO SUM function in excel?

Answer 1

Autosum allows you to automatically insert the SUM function into a cell. It will then also automatically select a group of cells to add if there are cells with numbers in them nearby. If you do it at the bottom of a column of numbers, it will automatically select the ones above to sum and if you put it at the end of a row of numbers, it will automatically select the numbers in that row to sum. You still have the option of choosing a different range of cells to sum. Autosum also gives you the option to do other common operations such as MAX, MIN, AVERAGE, COUNT and COUNTA instead of using SUM.
SUM is the total of a range of numbers.

EXAMPLE:

=SUM(A1:A12) [Adds all of the numbers in cells A1 through A12.]

Answer 2

Example:

1. Enter the following data into cells C1 to C6:

   11, 12, 13, 14, 15, 16

2. Make sure that cell C7 - the location where the results will be displayed is blank.
3. Drag select cells C1 to C6 in the spreadsheet.
4. Click on the Home tab.
5. Click on the AutoSum button on the ribbon to enter the SUM function into cell C7.
6. Press the ENTER key on the keyboard to accept the function.
7. The answer 81 should appear in cell C7.
8. Click on cell C7 and the complete function = SUM (C1 : C6) appears in the formula bar above the worksheet.

------------------------------------------------

added by GBaughma

Put the cursor in the cell under a column of numbers you wish to sum.

Press Alt= (Alt plus Equals)

Answer 3

its activated by the sigma character on the tool bar

highlight a column range or row range of numbers plus an empty cell after

click the symbol and it automatically places the formula =sum(xx:yy) in that last cell.

eg =sum (b1:b16) you can do multiple columns or rows at once and each will be totalled at end

Answer 4

It's primary purpose is to instigate the SUM function and sum a range of cells close by that are likely to be summed. Usually it is a group of cells with numbers that are in a column above or a row to the left of the active cell or selected cells. In more recent versions of Excel it also gives the choice of using other functions instead of SUM such as AVERAGE or COUNT.

It's primary purpose is to instigate the SUM function and sum a range of cells close by that are likely to be summed. Usually it is a group of cells with numbers that are in a column above or a row to the left of the active cell or selected cells. In more recent versions of Excel it also gives the choice of using other functions instead of SUM such as AVERAGE or COUNT.

It's primary purpose is to instigate the SUM function and sum a range of cells close by that are likely to be summed. Usually it is a group of cells with numbers that are in a column above or a row to the left of the active cell or selected cells. In more recent versions of Excel it also gives the choice of using other functions instead of SUM such as AVERAGE or COUNT.

It's primary purpose is to instigate the SUM function and sum a range of cells close by that are likely to be summed. Usually it is a group of cells with numbers that are in a column above or a row to the left of the active cell or selected cells. In more recent versions of Excel it also gives the choice of using other functions instead of SUM such as AVERAGE or COUNT.

It's primary purpose is to instigate the SUM function and sum a range of cells close by that are likely to be summed. Usually it is a group of cells with numbers that are in a column above or a row to the left of the active cell or selected cells. In more recent versions of Excel it also gives the choice of using other functions instead of SUM such as AVERAGE or COUNT.

It's primary purpose is to instigate the SUM function and sum a range of cells close by that are likely to be summed. Usually it is a group of cells with numbers that are in a column above or a row to the left of the active cell or selected cells. In more recent versions of Excel it also gives the choice of using other functions instead of SUM such as AVERAGE or COUNT.

It's primary purpose is to instigate the SUM function and sum a range of cells close by that are likely to be summed. Usually it is a group of cells with numbers that are in a column above or a row to the left of the active cell or selected cells. In more recent versions of Excel it also gives the choice of using other functions instead of SUM such as AVERAGE or COUNT.

It's primary purpose is to instigate the SUM function and sum a range of cells close by that are likely to be summed. Usually it is a group of cells with numbers that are in a column above or a row to the left of the active cell or selected cells. In more recent versions of Excel it also gives the choice of using other functions instead of SUM such as AVERAGE or COUNT.

It's primary purpose is to instigate the SUM function and sum a range of cells close by that are likely to be summed. Usually it is a group of cells with numbers that are in a column above or a row to the left of the active cell or selected cells. In more recent versions of Excel it also gives the choice of using other functions instead of SUM such as AVERAGE or COUNT.

It's primary purpose is to instigate the SUM function and sum a range of cells close by that are likely to be summed. Usually it is a group of cells with numbers that are in a column above or a row to the left of the active cell or selected cells. In more recent versions of Excel it also gives the choice of using other functions instead of SUM such as AVERAGE or COUNT.

It's primary purpose is to instigate the SUM function and sum a range of cells close by that are likely to be summed. Usually it is a group of cells with numbers that are in a column above or a row to the left of the active cell or selected cells. In more recent versions of Excel it also gives the choice of using other functions instead of SUM such as AVERAGE or COUNT.

Answer 5

It's primary purpose is to instigate the SUM function and sum a range of cells close by that are likely to be summed. Usually it is a group of cells with numbers that are in a column above or a row to the left of the active cell or selected cells. In more recent versions of Excel it also gives the choice of using other functions instead of SUM such as AVERAGE or COUNT.

Answer 6

If you want to sum all the values in one column, then you just need to select the last empty cell and press Alt + '=' key. This will add all the values present in the highlighted column.

Answer 7

The Σ which is the Greek letter sigma and is used to indicate sum of.

Answer 8

Adds highlighted cells

Answer 9

It adds up a range of cell values.