Use AutoSum to sum numbers

If you need to sum the contents of a column or row, let Excel do the math for you.

On your iPad

1. To sum a column of numbers, tap to select the cell immediately below the last number in the column.

   

2. On the Formulas tab, tap AutoSum .

   

3. Tap Sum and then tap return.

   

   You're done!

   

On your iPhone

1. Tap to select the cell immediately below the last number in the column.

   

2. Tap the ribbon button .

3. Tap Formulas.

   

4. Tap AutoSum.

   

5. Tap Sum.

   

6. Tap the check mark.

   

   You're done!

   

On your Android tablet or Android phone

1. In a worksheet, tap the first empty cell after a range of cells that has numbers, or tap and drag to select the range of cells you want to calculate.

   

2. Tap AutoSum.

   

3. Tap Sum.

   

4. Tap the check mark.

   

   You're done!

   

On your Windows tablet or phone

1. In a worksheet, tap the first empty cell after a range of cells that has numbers, or tap and drag to select the range of cells you want to calculate.

   

2. Tap AutoSum.

   

3. Tap Sum.

   

4. Tap the check mark.

   

   You're done!

   

Top of Page