Excel Tutorial
Excel tutorials, quizzes & AI guides — all levels
RSS
  • Online Excel Exercises
  • Training
  • Excel Tests
  • Sitemap
  • Premium Quizzes
  • Shop
  • My account

Solve SUMIF Exercise: Answer Fun Questions

Do you want to learn SUMIF and make your Excel skills stronger?

This fun SUMIF exercise is perfect for beginners! By the end, you will master SUMIF and calculate totals easily. You will answer 8 questions, one on each page, and see your final result at the end. The last question is for the pro 😉

Let's make learning Excel fun and simple!

How It Works:

  1. Start with basic questions, like adding sales for jeans.
  2. Move to harder ones, like calculating totals for colors not "Pink."
  3. Use SUMIF with logical operators (like greater than 10,000).
  4. Check your results at the end of the exercise.
Table Size Clothes for SUMIF exercise

Click to begin the exercise and see how much you can master SUMIF.

SUMIF with operators — Sales portfolio

Total sales above or below a threshold using SUMIF with comparison operators — 8 guided steps, no fill-down.

=SUMIF( range , ">value" )

1 / 8

Amounts greater than $3,000

SUMIF Operators — Q1 · 575

=SUMIF(E2:E16,">3000")

=SUMIF( range , ">=value" )

2 / 8

Amounts of $4,000 or more

SUMIF Operators — Q2 · 576

=SUMIF(E2:E16,">=4000")

=SUMIF( criteria_range , "criteria" , sum_range )

3 / 8

Garcia's total revenue

SUMIF Operators — Q3 · 577

=SUMIF(A2:A16,"Garcia",E2:E16)

=SUMIF( range , "

4 / 8

Amounts below $2,000

SUMIF Operators — Q4 · 578

=SUMIF(E2:E16,"<2000")

=SUMIF( range , "<=value" )

5 / 8

Amounts of $3,000 or less

SUMIF Operators — Q5 · 579

=SUMIF(E2:E16,"<=3000")

=SUMIF( criteria_range , "criteria" , sum_range )

6 / 8

Total revenue for the East region

SUMIF Operators — Q6 · 580

=SUMIF(C2:C16,"East",E2:E16)

=SUMIF( range , ">="&cell )

7 / 8

Amounts greater than or equal to G1

SUMIF Operators — Q7 · 581

=SUMIF(E2:E16,">="&G1)

=SUMIF( range , ">"&cell )

8 / 8

Amounts strictly greater than G1

SUMIF Operators — Q8 · 582

=SUMIF(E2:E16,">"&G1)

Your score is

0%

Related Articles

  • Step-by-step guide for SUMIF function
  • Training with the SUMIF and SUMIFS functions

Excel-Tutorial.com, your training partner.

The purpose of Excel-tutorial.com is to help users master Excel through a series of tests, tutorials, and online training programs. Whether you're a beginner or an advanced user, our resources are designed to build your skills step by step.

Our certified experts have developed detailed training programs tailored to all skill levels. Our courses cover various Excel topics, from basic data processing to advanced data analysis and visualization. You'll find clear instructions, easy-to-follow lessons, and structured content that ensures steady progress.

Excel-tutorial.com stands out for its interactive teaching approach. Our lessons include exercises, real-life use cases, and engaging quizzes to solidify your understanding. This lets you apply your new skills immediately to real-world tasks, making learning both practical and impactful.

Plus, you can track your progress and test your knowledge with quizzes that provide instant feedback. Our goal is to help you gain confidence in Excel, one concept at a time. Join us at Excel-tutorial.com and start transforming your data skills today!

Most Viewed Posts

  • Displaying Negative Numbers in Parentheses in Excel (309,767)
  • Top 10 Excel Functions You Must Know (231,843)
  • How to make automatic calendar in Excel (212,378)
  • Dash for a zero in Excel automatically (190,135)
  • Converting a Date from YYYYMMDD to DD/MM/YYYY in Excel (170,144)
  • Date Format in Excel (154,577)
  • Use Excel Online for Free (134,547)
  • Excel Split Date and Time (133,316)
  • How to calculate VAT in Excel? (126,954)
  • Exchange rate in Excel 🏛️ (124,156)
  • Add Emojis to your Excel charts or slicers (116,880)
  • Why Excel Formulas Use Comma or Semi-Colon (101,699)
  • Master XLOOKUP function in Excel (101,695)
  • UNIQUE Function – Remove duplicates with formulas (97,897)
  • Change the default Date format in Excel (94,500)

Contact us
About me 
Privacy Policy

© 2022 – 2026 – excel-tutorial.com. All Rights Reserved.
Excel Tutorial is managed by majordome du net

Contact us
About me 
Privacy Policy

© 2022 – 2026 – excel-tutorial.com. All Rights Reserved.
Excel Tutorial is managed by majordome du net