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

  1. Click a cell and type =.
  2. Start a function’s name. Cloud Sheets lists matching functions. Press Tab to pick one.
  3. As you type, the arguments show under the cell. Click or drag over cells to put their address in.
  4. 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

  • A1 changes when you copy the formula. $A$1 doesn’t. A$1 and $A1 fix only the row or only the column.
  • Sheet2!B4 points to another sheet. A table column is written TableName[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.

Was this article helpful?