Practice challenge
Average overtime hours
#18
3 attempts remaining
IntermediateEmployee hoursTarget D2
A manager wants the average hours for employees above 40 hours.
Write a formula for D2 that averages hours greater than 40.
Average overtime hours
Swipe horizontally to view the full table.
| A | B | C | D | |
|---|---|---|---|---|
| # | Employee | Hours | Team | Avg overtime |
| 2 | Nora | 43 | Ops | blank |
| 3 | Omar | 39 | Sales | blank |
| 4 | Iris | 45 | Ops | blank |
| 5 | Leo | 41 | Support | blank |