Skip to content

Help centre · Digits (spreadsheets)

Digits — formulas, references, and named ranges

Last updated · 6 June 2026 · 6 min read

How references work in Digits, the supported formulas, and how to use named ranges.

Digits uses standard A1-style references and a familiar set of formulas. You write =SUM(A1:A10) and it just works.

References

  • A1 — relative reference (shifts when copied)
  • $A$1 — absolute reference (locked)
  • A$1 / $A1 — mixed (row or column locked)
  • Sheet2!A1 — cross-sheet reference

Supported formula categories

  • Math: SUM, AVERAGE, MIN, MAX, ROUND, ABS, MOD, POWER, SQRT
  • Logical: IF, IFS, AND, OR, NOT, XOR, IFERROR
  • Lookup: VLOOKUP, HLOOKUP, INDEX, MATCH, XLOOKUP
  • Text: CONCAT, LEFT, RIGHT, MID, LEN, UPPER, LOWER, TRIM
  • Date: TODAY, NOW, DATE, YEAR, MONTH, DAY, WEEKDAY, NETWORKDAYS
  • Statistical: COUNT, COUNTA, COUNTIF, STDEV, MEDIAN, PERCENTILE

Named ranges

Select a range, hit Ctrl/⌘ + Shift + N, and give it a name like Revenue. Then =SUM(Revenue) works anywhere in the workbook.

Was this helpful?

Contact support