Average the records that qualify
Your goal: Choose the intended region and delivery state, keep real zeros, and distinguish missing measurements from observations.
Full task requirements
In G5, average numeric hours for the region in G2 and state in G3. Include numeric zero, ignore blank/text measurements, and show No numeric records when none qualify.
Completed East deliveriesChoose the matching population
- Region
- East (G2)
- State
- Delivered (G3)
| # | |||
|---|---|---|---|
| 1 | |||
| 2 | |||
| 3 | |||
| 4 | |||
| 5 | |||
| 6 | |||
| 7 | |||
| 8 |
Step 1 of 2
Choose the matching population
How the Excel rule works
First match region AND state. A record can belong to this population even when its measurement is blank or text.
Inspect selected records
No records selected yet.