(lively music) <v Instructor>In this video,</v> we'll learn how to use the COUNTIF function. The COUNTIF function is perfect for answering questions like how many products sold more than 150 units, like we're gonna look at in this example. So we're gonna count how many products have sold more than 150 units using the COUNTIF function. And the data we'll be using is in the units sold column, column C. So from C2 to C31. We want to display the result in the cell J4. So go ahead, click and select cell J4. To use the COUNTIF function, start by typing an equal sign. This tells the software that you're entering a calculation. Then type COUNTIF, open brackets. Now click and drag to highlight cells C2 to C31. (lively music) This is telling the function where to look. Now we need to type in a condition. So we want to type a comma. So we've selected the range. Now we need to put in the condition, the criteria for our search. In this case, we wanna search for values that are greater than 150. So we type double quotes, greater than, which is shift and full stop on your keyboard. And then 150, double quotes again, and close your bracket. So let's recap this. The completed formula now reads =COUNTIF, and then in brackets is our range, C2 to C31. That's the range, but this time we're adding a criteria to that. So we add a comma to separate the range and the criteria. The criteria, in this case, we put in double quotes. Then we type the greater than symbol followed by the value. So we're only counting the number of cells that contain a value greater than 150. Once you're confident that your formula is correct, you press enter. We can see that the number of products sold more than 150 units equal 11. So it's counted the number of cells that has a value greater than 150. It does not add or count the values within those cells. It's just counting the cells and how many cells have a value greater than 150. So please make sure that you understand that. This is a really quick and easy way to count data that meets a specific condition. So using COUNTIF, you can answer questions like how many items sold more than 150, or how many scores were above a certain number, how many students scored more or greater than 80% in their test, and so on. It saves time and it makes analysing your data so much easier. So now it's your turn. Use the COUNTIF function in cell J4 to count the number of products with sales greater than 150 units. Good luck. (lively music ending).