Difficulty
Beginner
Estimated Time
10–15 minutes
The Problem
You are given a simple sales dataset containing individual transactions.
Each row represents a sale of a product on a given date.
Your task is to calculate the total sales amount per product using Excel formulas.
This is a foundational Excel skill used in reporting, dashboards, and financial summaries.
The Dataset
Create a worksheet named SalesData with the following columns:
| Date | Product | Quantity | Unit Price |
|---|---|---|---|
| 2025-01-02 | Laptop | 2 | 900 |
| 2025-01-02 | Mouse | 5 | 20 |
| 2025-01-03 | Laptop | 1 | 900 |
| 2025-01-03 | Keyboard | 3 | 45 |
| 2025-01-04 | Mouse | 2 | 20 |
| 2025-01-05 | Laptop | 1 | 900 |
Your Task
- Add a new column called Sales Amount
- Calculate the sales amount for each row
- Create a summary table that shows:
- Product
- Total Sales Amount per Product
Requirements
- Use Excel formulas only (no Pivot Tables yet)
- Use structured, readable formulas
- The solution should update automatically if new rows are added
Expected Output
Your final summary table should look like this:
| Product | Total Sales |
|---|---|
| Laptop | 3600 |
| Mouse | 140 |
| Keyboard | 135 |
Hints (Optional)
- Sales Amount = Quantity × Unit Price
- Think about which Excel function is designed to sum values based on a condition
- Try to avoid hard-coding values
Learning Objectives
By completing this challenge, you will practice:
- Writing basic Excel formulas
- Creating calculated columns
- Using conditional aggregation
- Structuring data for reporting
These skills are essential for dashboards, Power BI prep, and SQL-style thinking in Excel.
What’s Next?
In the next challenge, you’ll build on this dataset to:
- Add date filtering
- Introduce multiple conditions
- Prepare the data for a dashboard-style summary
Next Challenge
Excel Challenge #2: Total Sales by Product and Month (First Pivot-Style Summary)
🔗 View reference solution on GitHub
(After you’ve tried the challenge)
Want more practical Excel challenges?
Subscribe to the Solve With Excel newsletter and get new problems delivered to your inbox.
SolveWithExcel 