Free exercises COUNTIF(S) and SUMIF(S) functions

I have prepared two Excel tables with data and many tasks to use COUNTIF(S) and SUMIF(S). Each task contains also the result.

Exercise 1

The first table contains Orders and Transport information. Data come from a big wholesale of electronics.

Table 1

There are some of the tasks:

Exercise1

Exercise 2

The second table contains data from Hairdressers and barbers. There is information about each customer in May 2013. What Service, Stylist, Price, Payment and when.

Table 2

Your task is to find some statistical values. The results are included on the third sheet.

Exercise2

These exercises are for free and you can use them, change them or copy them. If you find any mistake, please leave a comment.

Free download: countif sumif exercises.xlsx

Add a comment »25 comments to this article

  1. PURRFECT I HAVE EXAM TMRW OF ICT N I AM IN GRADE 7!

    THIS HELPED ME A LOT!!!

    Reply

  2. How to sumif multiple ranges in excel? I have 3 criteria in the table.

    Reply

    • Hi,

      use SUMIFS function. Each Criteria range has its own criteria field. Criteria_range1 – Criteria1, Criteria_range2 – criteria2, …

      Reply

  3. Thank you so much for sharing this exercise! I found it really helpful and I feel more competent with the use of COUNTIFS and SUMIFS.

    Reply

  4. Can you show the formulas you used please

    Reply

    • Hello,

      there are results in each sheet. If you click in the cell you will see the formula.

      Reply

  5. GBFG

    Reply

  6. How can I download COUNTIFS example?

    Reply

    • Hello,

      COUNTIFS and SUMIFS examples are part of this Excel file. Click on the link Free download… to get it.

      Reply

  7. Please give me the answers for this exercises.

    Reply

    • Hello,

      answers are included in file.
      Exercise 1 has answers in column H (results).
      Exercise 2 has answers in separated sheet Exercise 2 – result.

      Reply

  8. Really simple exercise to learn how to use COUNTIFS and SUMIFS.

    Thank you.

    Reply

    • Sir Can I have the answers for this exercises please?

      Reply

  9. Thanks, with the practice of your exercises I started doing this more smoothly.
    Real thanks :)

    Reply

  10. VERY nice and healthy exercise for the excel beginners.

    Thanks Sir or Mam, who is behind this.
    Pradip

    Reply

  11. Thank you!!

    Reply

  12. Thank you very much Jan Podlesak. Good job!

    Reply

  13. It is a helpful and useful exercise for learner as me. I hope that you will upload more exercises which are related to all excel formulas!

    Reply

  14. Brilliant exercises! Well done and thank you! :o)j

    Reply

  15. Thanks for the quiz. It has helped my mastery of countifs and sumifs.

    Reply

  16. Really helpfull excercise……………..

    Reply

  17. I have a doubt in doing the question, (sum of items transported by trucks) And ty

    Reply

  18. hei dear, pls help me with these, i am making an excel table to get auto update in point table *meaning-when ever i put a score on match schedule list, it will automatically update in the point table
    HELP- i need to look for “TEAM A” name and if its score is greater than the “TEAM B” score then MATCHES won should reslut as”1″, like below

    A B C
    1 Team name|vs|Team name
    2 3 | | 4
    3
    4

    point table
    MP W D L GF GA GD
    TEAM A 1 0 0 1
    TEAM B 1 1 0 0

    Reply

  19. THANK YOU FOR HELPING US

    Reply

  20. Good exercise

    Reply



Copyright © All Rights Reserved · Green Hope Theme by Sivan & schiy · Proudly powered by WordPress