COUNTIFS Function - Free Excel Practice Online

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

1. The COUNTIFS function counts the number of rows or columns where all conditions are met. To find the number of companies located in the USA whose record value exceeded 1 trillion, try typing =COUNTIFS(B2:B7, "USA", C2:C7, ">1").
2. The COUNTIFS function counts the rows where all conditions are correct. What would =COUNTIFS(B2:B8, "MO", C2:C8, ">2000") return?
3. The COUNTIFS function supports wildcard matching. What would =COUNTIFS(B2:B8, "M*", C2:C8, ">2000") return?
4. Write a COUNTIFS function to count the number of cities whose names start with "M" where crime is above 1550.
5. What would =COUNTIFS(A2:A8, "M*", C2:C8, ">1550") return?
6. What would =COUNTIFS(A2:A8, "M*", C2:C8, ">1600") return?
7. What would =COUNTIFS(A2:A8, "M*", C2:C8, ">2200") return?
8. Write a COUNTIFS formula to find the number of cities in the USA where the average July temperature is greater than 90.
9. What would =COUNTIFS(B2:B8, "USA", C2:C8, ">90") return?
10. What would =COUNTIFS(B2:B8, "*", C2:C8, ">90") return?

COUNTIFS Function practice - FAQ