COUNTIF Function - Free Excel Practice Online

This free, interactive exercise teaches you COUNTIF Function 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 COUNTIF Function 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 COUNTIF Function lesson

1. The COUNTIF function counts the number of text, date, or numerical cells that meet a certain condition. Type =COUNTIF(B2:B8, "MN") to get the number of branches in Minnesota (3)!
2. The COUNTIF function also works with the logical operators inside the quotes. Try =COUNTIF(C2:C8, ">500") to get the number of branches with sales over 500 (3)!
3. The COUNTIF function supports wildcard matching of text. What would =COUNTIF(A2:A8, "M*") return? Hint: It counts any string that starts with "M".
4. Wildcard matching with "?" specifies the exact number of characters. What would =COUNTIF(A2:A8, "M??????") return? Hint: It counts any string that starts with "M" and is 7 characters long.
5. What would =COUNTIF(C2:C8, ">=500") return?
6. Write a COUNTIF function that returns the number of branches where sales was less than 200.
7. Write a COUNTIF function that returns the number of branches where sales was not equal to 500.
8. What would =COUNTIF(A:B, "M*") return?
9. What would =COUNTIF(A:B, "M?") return?
10. COUNTIF is not case sensitive. What would =COUNTIF(A:A, "mINneApOliS") return?

COUNTIF Function practice - FAQ