0 of 62
Conditions·Scenario·Lesson 27 of 62Pro

A small shop’s sales by rep and region

A real-world job using what the Conditions section covered.

What you’ll do

A furniture shop’s first-quarter sales. You’ll build a total for each rep, answer two questions the owner asks every month, and save a result as a plain number.

The steps

5 steps
  1. 1
    In I2, total the sales for the rep named in H2. Then fill it down to I5 so every rep gets a total.
  2. 2
    In I7, total the sales of Desk lamps in the West.
  3. 3
    In I8, count the orders with a quantity of 5 or more.
  4. 4
    In I9, find the biggest of the four rep totals.
  5. 5
    Keep a copy that won’t change: click I9 and press Ctrl+C Mac ⌘+C, then click I10 and press Ctrl+Shift+V Mac ⌘+Shift+V to paste the value only.

Scenario locked

Unlock the other 44 lessons for $49.99

Pro opens every drill, practice set, scenario, project and section review. One payment, yours to keep.

Unlock for $49.99