Excel Practice & Exercises with SUMIF Function

Get FREE Advanced Excel Exercises with Solutions!

This article contains 7 practice exercises for the Excel SUMIF function. You will need a basic understanding of accounting and Excel to solve all the problems. Additionally, you should know the following: the SUMIF function, SUMIF with multiple criteria, use SUMIF across multiple columns, use SUMIF with text, use SUMIF with date range, use SUMIF with OR logic, use the Fill Handle, ways to AutoFill the formulas, use custom cell formatting, Excel VBA, enable developer tab, and adjust background cell color features to find solutions to the problems. You can use any version of Excel to solve the problems.


Download Practice Workbook

You can download the Excel file from the following link.


Problem Overview

There will be seven practice exercises related to the Excel SUMIF function. Each problem has a distinct dataset. The “Problem” sheet shows the exercises, and the “Solution” sheet shows the problems worked out. The following image shows the dataset of this article. Additionally, you can press Alt+F11 to bring up the Excel VBA window to use the code.

Problem Overview

  • Exercise 01 SUMIF Greater Than Criteria: In this first exercise, your task is to find the total cost of the products sold that cost more than $1,000.

The following animated image shows the solution to the first problem. We have hidden some columns for better visualization.

  • Exercise 02 Set Cell Value as Criteria: Repeat the first problem, this time using the cell reference as the criteria.
  • Exercise 03 Total Selling Price per Sales Rep: Calculate the sales generated by both Ben and Jacob.
  • Exercise 04 Implementation of Wildcard Character: Find the total selling price of the brands that start with the alphabet A.
  • Exercise 05 OR Criteria with SUMIF Function: Calculate the total selling price of the brand from Sony or Acer.
  • Exercise 06 Profit Earned for the Month of July: Find the total profit for the month of July.
    • Hint: Profit = Selling Price – Cost Price
  • Exercise 07 Use of VBA SUMIF Function to Find Total Profit: Apply a VBA code to find the total profit for the company.

The image below shows all the solutions for this exercise.

Excel SUMIF Practice Exercises


Conclusion

Thank you for reading this article. By completing the Excel SUMIF practice exercises, we hope that you have gained knowledge about Excel. You can find more articles similar to this on the ExcelDemy website. If you have any questions or suggestions, feel free to comment below. However, remember that our website implements comment moderation. Therefore, your comment may not be instantly visible. So, have a little bit of patience, and we will solve your query as soon as possible. Keep excelling!

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.

Rafiul Haq
Rafiul Haq

Rafiul Haq worked as an Excel and VBA Content Developer in Exceldemy for over two years and published almost 200 articles for the website. He is passionate about exploring new aspects of Excel and VBA. He received his Bachelor of Science in Mechanical and Production Engineering (MPE) from the Islamic University of Technology. Rafiul furthered his education by obtaining an MBA in Finance from the Institute of Business Administration (IBA) at the University of Dhaka. Apart from creating... Read Full Bio

4 Comments
  1. very helpful exercise.sir.kindly make another exercise on another basic and advanced formulas

    • Dear Ramandeep Kaur,

      Thanks for your appreciation. Sooner we will make another exercise based on Basic and Advanced Formulas.

      Regards
      Shamima Sultana
      Project Manager | ExcelDemy

  2. Please Check Exercise 02 it is not working when I am trying in the problem section.

    • Reply Lutfor Rahman Shimanto
      Lutfor Rahman Shimanto Mar 10, 2024 at 11:28 AM

      Hello Hardik

      Thanks for visiting our blog and sharing your difficulties. To find the total cost of the products sold that cost more than $1,000 using cell value as Criteria:

      1. Select cell L9.
      2. Insert the following formula: =SUMIF(G6:G92, K9, G6:G92)
      3. Hit Enter to see the following output.

      Hopefully, the formula will overcome the situation; good luck.

      Regards

      Lutfor Rahman Shimanto

      ExcelDemy

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo