Excel Challenge 55: Analyze Sales With SUMIF & SUMIFS

Can you use Excel to analyze profitability by sales, region, or time period? That's the aim of this Excel practice exercise.

Everything you need to participate in the challenge can be found on this page. To take part:

• First, watch the challenge video and read the instructions below the video.
• Review the previously published video(s) and article(s) on which the challenge is based.
• Download the Excel worksheet you will use to complete the challenge tasks.
• Put yourself to the test!

The scenario

Anna and her dad operate a fruit stall in the market, and her dad wants the answer to the following questions:

• Which fruit makes the most money?
• Which region buys the most apples?
• Are we doing better than last month?

Fresh out of Excel training, Anna knows the answers are right at her fingertips.

The challenge

Your task is to help Anna build an Excel-based solution that answers her dad’s questions using conditional summing functions.

The data

Anna has already structured the data with the following columns:

• Selling Date
• Fruits Name (e.g., Apple, Banana, Kiwi)
• Units Sold, kg
• Unit Price $/kg
• Sold, $ (Units Sold, kg × Unit Price, $/kg)

What Anna needs to build

Anna wants to find out the following:

1. Total Sales Volume (kg)
2. Peach Sales Volume (kg)
3. Sum of sales of all types of Apples ($)
4. Sales Volume in kg for:

• pineapples
• mangoes
• grapes

5. Sales Volume in kg for:

• peaches until June 17, 2025
• all bananas for the period June 17 to June 30, 2025

6. Total sales from June 16, 2025 onward

Learning outcome

By solving this challenge, you’ll master:

• The difference between SUMIF and SUMIFS
• How to analyze sales data in Excel
• Real-world application of Excel functions for small business analysis
• Basic dashboard elements using formatting and formulas

Need a refresher? 

If you're just getting your feet wet or you need a quick refresher, we're here to help. Check out these helpful guides on how you might go about answering these questions.

How to Use SUMIF in Excel

How to Use the SUMIFS Function

The solution

Were you able to complete all the tasks? Here is how I solved the challenge!

Join our community of learners like you on Slack and get the solution file free, or show us your unique way of tackling this month's workout.

I hope you enjoyed taking part in this challenge. Stay tuned to the GoSkills Excel Resource hub for more Excel content, and check out our range of expert-led Excel courses for all skill levels to further sharpen your skills.