Practice challenge
Sum approved budget items
#8
3 attempts remaining
IntermediateBudgetsTarget E2
A budget sheet lists department requests and approval status.
Write a formula for E2 that totals amounts where the status is Approved.
Sum approved budget items
Swipe horizontally to view the full table.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| # | Department | Request | Status | Amount | Approved total |
| 2 | Ops | Software | Approved | 1,200 | blank |
| 3 | Sales | Events | Pending | 2,800 | blank |
| 4 | HR | Training | Approved | 900 | blank |
| 5 | Finance | Audit | Rejected | 1,500 | blank |