COUNT Practice - Free Excel Practice Online

This free, interactive exercise teaches you COUNT Practice in Excel through 10 hands-on steps. Instead of watching a video, you type the real formula into a live spreadsheet grid and get instant feedback on every answer. It is part of the COUNT Functions track and works right in your browser - no Excel install, no download, and no signup.

Practising COUNT Practice this way builds the muscle memory that transfers straight to using Excel at work, in interviews, or for certification prep. Work through the steps above, then keep going with the next lesson to build a complete, free Excel practice course.

What you'll practice in this COUNT Practice lesson

1. The table below shows crop production by country for 2018. You want to know the number of countries for which we have banana production data. The COUNT function counts the number of numerical values in a range of cells and will ignore text, so you can write the following function to count the number of countries for which we have banana production data:=COUNT(B:B)Try typing the formula into cell F2. What is the result of the formula?
2. Now you want to know the number of countries for which we have Coffee Bean production data. Use the COUNT function to find the answer and paste the number into the box below.
3. Now you want to know the number of countries which produce more than 800 tonnes of bananas. Use the following formula to find the answer:=COUNTIF(B:B, ">800")
4. Now you want to know the number of countries which produce more than 100 tonnes of avocados.
5. Now you want to know the number of countries for which we have data which produce LESS than 100 tonnes of coffee beans. Use COUNTIF to find the answer and paste the number below.
6. Now you want to know the number of countries which produce more than 100 tonnes of bananas AND less than 100 tonnes of avocados. Use the following formula to find the answer:=COUNTIFS(B:B, ">100", D:D, "
7. How many countries produce more than 200 tonnes of bananas and less than 200 tonnes of coffee beans?
8. How many countries produce more than 200 tonnes of coffee beans and have data on avocado production? Hint: The value in column D is not equal to "No Data".
9. How many countries produce more than 500 tonnes of avocados?
10. How many countries produce more than 500 tonnes each of bananas, coffee beans, and avocados?

COUNT Practice practice - FAQ