← Practice challengesFree companion · 15 minute suggested activity

Use SUMIFS with an explicit status

Excel practice · Use the supplied CSV with headers in row 1. Formulas use English function names and commas; your locale may use translated names or semicolons.

Learn → Try → ExplainReviewed 2026-10-15

Your task

Put completed in G2 and calculate completed sales in EUR. Write the metric definition and output unit before choosing a formula.

Hint

Use a separate calculation area so the raw source stays unchanged. Keep excluded rows and reconcile the total.

Worked solution

With CSV columns A:E, enter =SUMIFS(E2:E9,D2:D9,G2)/100. Expected EUR 700. Avoid including the header or treating cents as euros.

Boundary check

Change G2 to cancelled; expected EUR 90. Restore completed afterwards.

Make the reasoning yours.

Try the activity before reading its reference. Keep your sources, commands and assumptions with your work. Companion activities are unsaved self-practice and do not award a certificate or change lesson progress.

Resume guidance and examples are for learning and preparation only. They do not guarantee interviews, a job offer or employment.

Public registration, payments and new paid enrolment remain disabled. These free resources do not grant access to protected course modules.

Learner dashboard ↗ · Ask a question ↗