Lesson 13 · 15 min

Final project: Maya's June report

Put it all together

Maya is deciding what to bake more of next month, and whether rainy Sundays are worth it. Build her a one-page report.

Video coming soon

Read the short explanation and practise below: it takes about 15 minutes.

Use what you've learned: SUMIF per product, a SUM for the total, a share with $ so it fills down, MAX, and an IF to give Maya a straight answer.

Fill K2 to K6 with one SUMIF that points at the product name in column J (no typing product names!), then fill down.

Finish all tasks to earn your White Belt certificate.

Pointing the condition at J2 instead of typing “Sourdough loaf” means one formula works for every row.

LEO · YOUR TUTOR

Want another one? I've got more like this.