From ideas to data.
Try formulas, paste from Excel or import a CSV. This demonstration keeps your changes on this page only.
⬬
5 rows · 5 columns
ƒx
| # | |||||
|---|---|---|---|---|---|
| 1 | |||||
| 2 | |||||
| 3 | |||||
| 4 | |||||
| 5 | |||||
5 / 5 rowsA1 · 1 values
Formulas and shortcuts
Tab · Enter · Shift + ↑ ↓ ← → · Ctrl/Cmd + C / V
SUM · AVERAGE · MIN · MAX · COUNT · ROUND · ABS · IF · IFERROR · AND · OR · NOT · LEN · UPPER · LOWER · TRIM
=IFERROR(SUM(B1:B8)/$C$1, 0)