Formulas that keep up with your work
Over 450 functions, suggestions as you type, coloured references and arrays that spill. Formulas are worked out in the background, so typing never waits.
Over 450 functions
Maths, statistics, text, dates, lookups such as XLOOKUP and INDEX/MATCH, financial and engineering functions, plus dynamic arrays, LET and LAMBDA.
Suggested as you type
Functions are suggested as you type, and the one you're in shows its arguments. References are coloured in the formula and around their cells; click or drag to point one in.
Named ranges and spilling arrays
Name a range and use it: =SUM(Revenue). FILTER, SORT, UNIQUE and SEQUENCE spill into the cells below and beside them, and A3# refers to the whole result.
Help from Caity
Describe a formula and Caity writes it, or select one to have it explained. Give a column's header and a few examples, and Caity fills the rest.
Around every formula
Fill a series
Drag the fill handle: numbers keep their step, dates go a day at a time, months and quarters go round, and formulas move their references.
Errors that say why
A formula that can't be worked out shows its error with a red corner. Point at the cell to see why.
Worked out in the background
Typing never waits on formulas, and only what a change affects is worked out again.
The sum at a glance
Select numbers to see their sum, then click it for the average, minimum, maximum or count.
Work out the numbers together in Sheets
Every Business plan includes it, with Documents, Slides, Drive and the rest of your workplace.