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.
The first table contains Orders and Transport information. Data come from a big wholesale of electronics.
There are some of the tasks:
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.