Live playgroundNo login. No fluff.

Spreadsheet formulas, learnt the way they’re written.

Search 61 functions, run every example live against sample data, and copy the formula straight into Sheets.

Browse all formulasToday's challenge
61
Formulas
46
Shortcuts
30
Challenges
Live
F2
→
48,200
Sample data · sales.csvShowing rows 1–7 of 17 · highlighted cells in formula range
ABCD
1CompanyRegionQuarterRevenue
2Acme CoWestQ118,400
3Acme CoWestQ222,100
4Acme CoWestQ331,700
5Acme CoWestQ448,200
6GlobexEastQ114,200
7GlobexEastQ219,800
Try:
POPULAR

Popular formulas

View all 61→
SUM()
Returns the sum of a series of numbers and/or cells.
IF()
Returns one value if a condition is TRUE, another if FALSE.
QUERY()
Runs a Google Visualization API Query Language query across data.
SUMIFS()
Returns the sum of a range depending on multiple criteria.
VLOOKUP()
Vertical lookup. Searches the first column of a range and returns a value from a specified column.
LEFT()
Returns a substring from the beginning of a specified string.
DATE()
Constructs a date value from year, month, and day numbers.
IMPORTRANGE()
Imports a range of cells from a specified spreadsheet.
BROWSE

By category

7 categories
Lookup4 formulas
Find data across rows, columns, sheets.
VLOOKUPXLOOKUPINDEXMATCH
Math12 formulas
Sum, count, round, average: the workhorse.
SUMIFSSUMAVERAGECOUNTIF
Logic10 formulas
IF, AND, OR: branching and conditions.
IFIFSIFERRORIFNA
Text15 formulas
Slice, join, clean, transform strings.
CONCATENATETEXTJOINLEFTRIGHT
Date11 formulas
Today, datedif, networkdays: calendar math.
TODAYNOWDATEDIFDATE
Array7 formulas
QUERY, FILTER, ARRAYFORMULA: work on whole ranges.
ARRAYFORMULAFILTERQUERYUNIQUE
Web2 formulas
IMPORTRANGE, GOOGLEFINANCE: pull from outside.
IMPORTRANGEGOOGLEFINANCE
Timed race30problems · 3 min

Beat the clock. Find the formula.

180 seconds to solve as many of 30 puzzles as you can, each checked by a real formula engine against real data.

Practice run →