You're a sales operations analyst summarising regional performance. Columns A–C contain twenty raw sales records: Region, Quarter, Sales.
Your task:
- In cell E2, compute the total Sales where Region = "North" AND Quarter = "Q1".
- In cell E3, compute the total Sales where Region = "South" AND Quarter = "Q3".
- In cell E4, compute the total Sales where Region = "West" AND Quarter = "Q4".
Graded cells: E2, E3, E4.
Open this problem on a desktop to attempt it.