1. Open Google Sheets in a web browser and click the cell in which you want the formula's answer to appear.
2. Find the Formula Bar above the spreadsheet. It's a blank field to the right of the Fx symbol. Click in the field and type the equals symbol "=".
3. Type the function you want to add to the formula. For example, if you want to sum up a column of numbers, type "SUM" and click SUM when you see it appear in the list of functions.
4. Google Sheets automatically adds an open parenthesis.
5. Enter the range of cells you want to sum. You can type the range, such as A1:A9, or you can click and drag the mouse from the first cell in the range to the last.
6. Type the closing parenthesis and press Enter.
If you don't know the exact function you need, you can browse the list of functions. Click in the Formula Bar and choose Insert, then Function. Find the function you want from the menu and click it.
How to create Google Sheets formulas on a mobile device
1. Start the Google Sheets app on your Android or iOS device and tap the cell in which you want the formula's answer to appear.
2. On an Android phone, tap the fx symbol below the spreadsheet. On iOS, tap the Pencil icon at the bottom right, then tap the fx symbol.
3. In the list of functions, tap browse the categories. Tap the category you need followed by the function you want to insert in your formula.
4. Google Sheets guides you through creating the formula with formatting hints. Choose the cell or range of cells you need to properly complete the formula. To make a range of cells, tap the first cell in the range and then tap the last cell in the range.
5. Tap the checkmark to the right of the Function Bar.
