Are you ready to test your knowledge of Excel’s COUNTIF and COUNTIFS functions? Here, there are no multiple-choice questions: you write the formulas yourself, in a real spreadsheet, directly in your browser.
Each formula is checked as you type, so you know straight away whether your answer is correct. It’s the best way to find out what you really master.
Start with COUNTIF on a file of 15 clients, in 6 steps, free:
👉 Now with two criteria: in cell G2, count the clients who are Married and have 2 children.
The answer is =COUNTIFS(C2:C16,”Married”,D2:D16,2). Each range is followed by its own criterion.
👉 Want to do more exercises? The full COUNTIFS exercise (8 steps), and many more on COUNTIF, SUMIF and the other Excel functions, are waiting for you here: all our online Excel exercises.
Brief Explanation of COUNTIF and COUNTIFS
- COUNTIF: This function counts the number of cells that meet a single criterion. It’s perfect for quickly finding how many cells contain a specific value or match a certain condition.
- COUNTIFS: An extension of COUNTIF, this function allows you to count cells based on multiple criteria. It’s useful when applying more than one condition to filter and count data accurately.
Excel-Tutorial.com, your training partner.
Our certified experts have developed detailed training programs tailored to all skill levels. Our courses cover various Excel topics, from basic data processing to advanced analysis.
What sets excel-tutorial.com apart from other training sites is our interactive teaching approach. Exercises and real-life use cases accompany our lessons. So you can apply your new skills immediately to your day-to-day work.