Numbers User Guide for iPhone
- Welcome
- What’s new
-
- Get started with Numbers
- Intro to images, charts and other objects
- Create a spreadsheet
- Open spreadsheets
- Prevent accidental editing
- Personalise templates
- Use sheets
- Undo or redo changes
- Save your spreadsheet
- Find a spreadsheet
- Delete a spreadsheet
- Print a spreadsheet
- Change the sheet background
- Copy text and objects between apps
- Touchscreen basics
- Change Numbers privacy and analytics settings
- Copyright
Quickly calculate a sum, average and more in Numbers on iPhone
You can make calculations in your table without having to insert a formula or function.
Make quick calculations for a range of cells
Go to the Numbers app
on your iPhone.In a spreadsheet, select the column or row (or the range of cells) whose calculations you want to see.
Tap
at the bottom of the screen, then tap the formula you want to use.If you selected an entire column or row, tap
or 
, then tap the formula you want to use.The result of the formula appears at the end of your selection.
Use the Formula Editor like a calculator
You can enter number values in formulas to make calculations, just as you would in a calculator.
Go to the Numbers app
on your iPhone.In a spreadsheet, tap a blank cell where you want to add your formula, then type the equals sign (=) to open the Formula Editor.
Type the equation you want to calculate using values and arithmetic operators (for example, +, -, * and /).
For example, if you type the equals sign (=), then type “1+1” in the Formula Editor, the cell returns the result of 2. You can also use brackets; if you type 4+6*(3-1), the cell returns the result of 16.