=SUMIF(B2:B8,Travel,C2:C8)
Text in a formula needs double quotes: "Travel".
Practise Excel formulas on real tasks in a live sheet. When something’s off, the feedback names the part to fix.
Free, with no sign-up. Your progress is saved in this browser.
One formula. A lot less adding up.
In B10, total the Travel expenses.
| A | B | C | |
|---|---|---|---|
| 1 | Item | Category | Amount |
| 2 | Taxi to airport | Travel | 42.50 |
| 3 | Team lunch | Meals | 86.00 |
| 4 | Hotel, 2 nights | Travel | 310.00 |
| 5 | Printer ink | Office | 38.90 |
| 6 | Client dinner | Meals | 124.00 |
| 7 | Train ticket | Travel | 27.00 |
| 8 | Notebooks | Office | 15.60 |
| 9 | |||
| 10 | Travel total | (answer cell) |
Scroll the sheet sideways to see every column.
That’s one row. Excel Foundations has 96 more tasks, from your first formula to XLOOKUP. Carry on in the free course
“Incorrect” doesn’t help anyone. These are our checker’s real replies to four slips on the task above.
=SUMIF(B2:B8,Travel,C2:C8)
Text in a formula needs double quotes: "Travel".
=SUMIF(B2:B8,"Travel",C2:C8
Check the closing bracket. SUMIF( opens a bracket, so the formula needs a ) to close it.
=379.5
Your formula doesn’t use the sheet. Point it at the cells that hold the data, so the answer updates when they change.
=SUMIF(B:B,"Travel",C:C)
This formula uses its own cell (B10), so it can never finish. Point it at other cells.
It also reruns your formula on changed data, so it catches formulas that are right by luck: a range that stops a row short, or a condition read from the wrong cell.
Each lesson explains one idea, then gives you a task on labelled example data.
Type in a live grid with a formula bar. Click cells to point at them, fill down and undo: the moves you’ll use in Excel.
Feedback arrives when you check, and hints step in when you’re stuck. Finish a task and your progress sheet gains a row.
Excel Foundations comes first, and it’s free. Pro tracks follow on the same live sheet.
Useful skills for everyday work. Eight modules take you from your first formula to SUMIF and XLOOKUP, then a final test.
Timed practice tests at basic and intermediate level, scored by skill.
Dates, INDEX and MATCH, FILTER, SORT, UNIQUE, tables and data cleaning.
SUMPRODUCT, LET, what-if models and a dashboard project.
SELECT, WHERE, GROUP BY and JOINs, with queries running in your browser.
Each page explains a function, shows the mistakes that trip people up, and gives you live tasks to check.
$0
For learning the essentials
$12 a month, or $72 a year
For building skills over time
$19 once, for 30 days
For an Excel test coming up
Planned launch prices. Paid plans open at the full launch. Compare the plans
No. Lessons run in your browser, in a practice sheet built for learning. The formulas you write are the same ones you’d type in Excel.
Excel Foundations is free: every lesson, the final test and the certificate of completion. Pro adds the later tracks, unlimited timed tests and skills reports.
Now. Excel Foundations is free to practise in your browser, with no sign-up. Accounts, the Pro tracks and paid plans come with the full launch.
In your browser, on this device. Clearing your browsing data resets it. Accounts that keep your progress across devices come with the full launch.
No. Passing the Foundations test earns a certificate of completion from The Next Row. It shows you finished the course. It isn’t an accreditation or a Microsoft certification.
Foundations covers the core formulas, from SUM to SUMIF and XLOOKUP. The planned Test Prep track adds timed tests at basic and intermediate level, scored by skill. We don’t use any test provider’s questions.
SQL Foundations is planned for 2027, on the same practice engine, with queries running in your browser.
Excel Foundations is free, with no sign-up. Your progress is saved in this browser.