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.
There are some of the tasks:
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.
Your task is to find some statistical values. The results are included on the third sheet.
These exercises are for free and you can use them, change them or copy them. If you find any mistake, please leave a comment.
Thanks a lot for sharing. I did not find as simple exercise as this. And it is for free. Great!
Is it possible to use COUNTIFS and SUMIFS in Google spreadsheets?
Yes. You can use both functions in Google spreadheets. The syntax is here:
SUMIFS(sum_range, criteria_range1, criterion1, [criteria_range2, criterion2, …])
Thank you for this simple explanation. What is the difference between COUNTIF(SUMIF) and pivot table? I have a big data table and I need to create overview statistics from this source. I don’t know which way is better.
Hi
thanks for shearing!
Regards
Great exercise, my learners lved the challenge of working out the functions. Thanks
On exercise 2, the total price is incorrect. For example, the total times “shaving” is 71. The cost per shave is $7.00. So 71 times $7.00 is $497. Also the total price by cash is incorrect.
Sorry, I just notices that not all shaves are $7.00!
PURRFECT I HAVE EXAM TMRW OF ICT N I AM IN GRADE 7!
THIS HELPED ME A LOT!!!
How to sumif multiple ranges in excel? I have 3 criteria in the table.
Hi,
use SUMIFS function. Each Criteria range has its own criteria field. Criteria_range1 – Criteria1, Criteria_range2 – criteria2, …
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.
Can you show the formulas you used please
Hello,
there are results in each sheet. If you click in the cell you will see the formula.
GBFG
How can I download COUNTIFS example?
Hello,
COUNTIFS and SUMIFS examples are part of this Excel file. Click on the link Free download… to get it.
Please give me the answers for this exercises.
Hello,
answers are included in file.
Exercise 1 has answers in column H (results).
Exercise 2 has answers in separated sheet Exercise 2 – result.
Really simple exercise to learn how to use COUNTIFS and SUMIFS.
Thank you.
Sir Can I have the answers for this exercises please?
Thanks, with the practice of your exercises I started doing this more smoothly.
Real thanks
VERY nice and healthy exercise for the excel beginners.
Thanks Sir or Mam, who is behind this.
Pradip
Thank you!!
Thank you very much Jan Podlesak. Good job!
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!
Brilliant exercises! Well done and thank you! :o)j
Thanks for the quiz. It has helped my mastery of countifs and sumifs.
Really helpfull excercise……………..
I have a doubt in doing the question, (sum of items transported by trucks) And ty
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
THANK YOU FOR HELPING US
Good exercise