Languages
Back
Languages
SUM Function - Excel Android App
> ... PathwayConnect Frequently Asked Questions > Assignment Help for PC 101 W03 Application Activity: Introduction to Spreadsheets > SUM Function - Excel Android App
  1. Tap the cell in which you want to enter the SUM function.
  2. Tap the formula bar to activate the keyboard.
The first callout shows that you have to tap the cell where you want to enter the SUM function. The second callout shows that you have to tap the formula bar to activate the keyboard.

  1. If needed, tap the icon to open the number keyboard.
  2. Type the = symbol.
  3. Tap the icon to open the letter keyboard
The first callout shows that you can tap the keyboard icon with a number on it to open the number keyboard, if needed. The second callout shows that when you tap the equal symbol, it will appear on the formula bar. The third callout shows that you can tap the keyboard icon to open the letter keyboard.

  1. Type SUM after the = symbol. this will prompt Excel to show you some function options.
  2. Tap "SUM" in the list of the formula options.
  3. This will display some pre-set information.
The first callout shows that you must type SUM after the = symbol to prompt Excel to show you some function options. The second callout shows that you have to tap "SUM" in the list of the formula options. The third callout shows that this will display some pre-set information.

  1. Delete all the information in between the parenthesis ( ).
  2. Tap on the first cell that you want to add. This will create a cell reference. It will also create a box around the cell with a circle at the bottom.
  3. Tap, hold, and drag the circle so the box surrounds all the cells you want to add.
  4. Once the box surrounds all the cells you want to add, those cells will be referenced in the formula bar, for example: e.g., D2:D11. This group of cells is called a range.
  5. Tap the checkmark icon to confirm your edits to the cell.
The first callout shows that all the information in between the parenthesis should be deleted. The second callout shows that you have to tap on the cell that you want to add. This will create a cell reference and it will also create a box around the cell with a circle at the bottom. The third callout shows that you have to tap, hold, and drag the circle so the box surround all the cells you want to add. The fourth callout shows that when a box surrounds all the cells you want to add, those cells will be referenced in the formula bar. It's called a range. The fifth callout shows the green check mark that you have to tap to confirm the changes you made to the cell.

  1. The SUM function adds all cells in the range.
This image shows that the SUM functions adds all the cells in the range.

Enter Text or Numbers - Excel Android App
Format Cells to Currency - Excel Android App