Excel-Exercise-Free

 

1. This function count how many times a data, a word, a figure, is present in a range of cells

 

2. For instance, you want to make some statistics for your sells.

 

3. You want to count how many times your have sold the item CD-Rom. The problem is that you have not only the label CD-Rom in the column B.

4. Activate the cell B15 and write the name of the function
Formule de la cellule =COUNTIF(

5. Select the range of cells where are all the labels
Formule de la cellule B3 :B12

6. Insert a semicolon to split your parameter and write your criteria
Formule de la cellule "CD-Rom"

7. The formula is :
Formule de la cellule =COUNTIF(B3:B12;"CD-Rom")

 

8. "We search in the column where there is all the data between the cell B3 and B12 how many times we have the word 'CD-Rom'".

 

9. Note 1: si the criteria is a string or a condition, you must put your criteria between double quote

10. Note 2: It is possible (and recommended) to have the reference a cell instead of a wording in the function
Formule de la cellule =COUNTIF(B3:B12;B3)

11. Now, with this formula, you want to count how many orders are below 80.
Formule de la cellule =COUNTIF(E3:E12;"<80")

 

12. "We search in the range of cells E3 : E12, how many cells have a value lower than 80 ".

 

13. Try with the following exercise