# 【solved】How to do autosum in excel

## How do you total a column in Excel?

How to total columns in Excel with AutoSum

1. Navigate to the Home tab -> Editing group and click on the AutoSum button.
2. You will see Excel automatically add the =SUM function and pick the range with your numbers.
3. Just press Enter on your keyboard to see the column totaled in Excel.

## What is the formula for sum in Excel?

The Autosum Excel shortcut is very simple – just type two keys:

1. ALT =
2. Step 1: place the cursor below the column of numbers you want to sum (or to the left of the row of numbers you want to sum).
3. Step 2: hold down the Alt key and then press the equals = sign while still holding Alt.
4. Step 3: press Enter.

## How do I sum an entire column in Excel?

Argument name Description
number1 Required The first number you want to add. The number can be like 4, a cell reference like B6, or a cell range like B2:B8.

## How does Sumif formula work?

Sum an Entire Column

To add up an entire column, enter the Sum Function: =sum( and then select the desired column either by clicking the column letter at the top of the screen or by using the arrow keys to navigate to the column and using the CTRL + SPACE shortcut to select the entire column.