Write formulas and use functions
Updated November 13, 2026
Cloud Sheets has more than 550 functions, from SUM and VLOOKUP to XLOOKUP, FILTER, LET and LAMBDA, with dynamic arrays that spill into the cells below.
Type a formula
- Click a cell and type =.
- Start a function’s name. Cloud Sheets lists matching functions. Press Tab to pick one.
- As you type, the arguments show under the cell. Click or drag over cells to put their address in.
- Press Enter.
Other ways in
- Formulas › Insert function finds a function by name or what it does, then helps fill in each argument.
- Formulas also groups them: Financial, Logical, Text, Date & Time, Lookup, and Math & Trig.
- Home › AutoSum adds up the numbers above or to the left. Its list has Average, Count Numbers, Max, Min and More Functions… too.
References
A1changes when you copy the formula.$A$1doesn’t.A$1and$A1fix only the row or only the column.Sheet2!B4points to another sheet. A table column is writtenTableName[Column].
If something goes wrong
| You see | It means |
|---|---|
| #NAME? | A function or name isn’t known. Check the spelling. |
| #REF! | A cell it pointed to was deleted. |
| #VALUE! | An argument is the wrong kind, such as text where a number belongs. |
| #DIV/0! | It divides by zero or an empty cell. |
| #N/A | A lookup didn’t find what it looked for. |
| #SPILL! | A formula that spills has something in its way. Clear the cells below or to the right. |
Ask the assistant to explain an error in plain words.