Task: 01/--
Lives: 3 lives left
Score: 0000
Best: --

Formula Rush

Type the right spreadsheet formula or SQL query before the clock runs out. Spaces, case and ; or , don't matter.

Loading game…

Formula Rush

A task, a tiny table, a ticking clock. Type the spreadsheet formula or the SQL query that answers it. Case, spaces and ; or , don't matter: only the logic does.

10 tasks
Excel + SQL

How to play

Read. Each task comes with a small sheet (rows 2 to 7) or the orders table.
Type. Write the formula or query and press Enter. Several equivalent answers are accepted.
Hint. Stuck? A hint shows the shape of the answer, for half the points.
Learn. Every task ends with the accepted answers and why they work. 3 lives.

Quick tips

Name the shape first. SUM, COUNT, AVERAGE for totals; the IF versions (SUMIF, COUNTIF) as soon as there's a condition.
Mind the argument order. SUMIF(range to test, condition, range to add). SUMIFS puts the range to add first.

3 more tips in the Formula Rush guide →