Use AutoSum to sum numbers

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

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

    Select column for Autosum

  2. On the Formulas tab, tap AutoSum .

    Formulas tab

  3. Tap Sum and then tap return.

    AutoSum functions menu

    You're done!

    AutoSum total

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

    Select cell

  2. Tap the ribbon button Excel for Android Ribbon access menu .

  3. Tap Formulas.

    Formulas tab

  4. Tap AutoSum.

    Select AutoSum

  5. Tap Sum.

    Select Sum

  6. Tap the check mark.

    Check mark

    You're done!

    Sum complete

  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.

    Android tablet Excel AutoSum

  2. Tap AutoSum.

    Android tablet Excel AutoSum

  3. Tap Sum.

    Android tablet Excel Sum

  4. Tap the check mark.

    Check mark

    You're done!

    Sum complete

  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.

    Windows tablet Excel AutoSum

  2. Tap AutoSum.

    Windows tablet Excel AutoSum

  3. Tap Sum.

    Windows tablet Excel Sum

  4. Tap the check mark.

    Check mark

    You're done!

    Sum complete

Top of Page

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×