← Practice challengesFree companion · 15 minute suggested activity

Count completed Web orders

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

Count orders with channel Web and status completed. 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

=COUNTIFS(C2:C9,"Web",D2:D9,"completed") returns 3: R01, R04 and R05. COUNTIFS counts rows here because each row is a unique order.

Boundary check

Check the order IDs manually; a duplicated export row would invalidate the result.

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 ↗