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 »12 comments to this article

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

    Reply

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

    Thanks Sir or Mam, who is behind this.
    Pradip

    Reply

  3. Thank you!!

    Reply

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

    Reply

  5. 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

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

    Reply

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

    Reply

  8. Really helpfull excercise……………..

    Reply

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

    Reply

  10. 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

  11. THANK YOU FOR HELPING US

    Reply

  12. Good exercise

    Reply



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