Statistical =COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)

Quiz =COUNTIFS — 10 Questions

10 quiz questions about =COUNTIFS — test syntax, arguments, examples & errors!

Questions: 10 questions 15 questions Random 10 or 15 questions from the pool + shuffled options each time

← COUNTIFS ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Which is the correct syntax of =COUNTIFS?

Question 2 of 10 2/10

How many required arguments does =COUNTIFS have?

Question 3 of 10 3/10

Which category does =COUNTIFS belong to?

Question 4 of 10 4/10

Which formula is a valid example of =COUNTIFS?

Question 5 of 10 5/10

What is the output type of =COUNTIFS?

Question 6 of 10 6/10

Which use case fits =COUNTIFS?

Question 7 of 10 7/10

In =COUNTIFS, which is argument #2?

Question 8 of 10 8/10

Does =COUNTIFS return a dynamic array?

Question 9 of 10 9/10

Since which Excel version is =COUNTIFS available?

Question 10 of 10 10/10

Is argument “criteria_range1” required in =COUNTIFS?

Click a question to see the answer.

1. Which is the correct syntax of =COUNTIFS?

A. =COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…, 0)
B. =COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…) ✓
C. COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)
D. =AVERAGEIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)

Explanation: Correct syntax: =COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)

2. How many required arguments does =COUNTIFS have?

A. 2 ✓
B. 1
C. 3
D. 4

Explanation: =COUNTIFS has 2 required, 1 optional (3 total).

3. Which category does =COUNTIFS belong to?

A. Lookup & Reference
B. Engineering
C. Cube
D. Statistical ✓

Explanation: Category is “Statistical”.

4. Which formula is a valid example of =COUNTIFS?

A. =AVERAGEIFS(B2:D2,"=Yes")
B. =COUNTIFS(B2:D2,"=Yes") ✓
C. COUNTIFS(B2:D2,"=Yes")
D. =COUNTIFS(B2:D2,"=Yes", 0)

Explanation: Correct example: =COUNTIFS(B2:D2,"=Yes")

5. What is the output type of =COUNTIFS?

A. Logical
B. Array
C. Reference
D. Number ✓

Explanation: Output is “Number”.

6. Which use case fits =COUNTIFS?

A. Scientific & Unit Conversion
B. Rounding & Numeric
C. Error Handling
D. Daily Tasks ✓

Explanation: Use case “Daily Tasks” fits COUNTIFS.

7. In =COUNTIFS, which is argument #2?

A. value
B. criteria_range1
C. criteria1 ✓
D. criteria

Explanation: Argument #2 is “criteria1”.

8. Does =COUNTIFS return a dynamic array?

A. No
B. No ✓
C. Yes
D. —

Explanation: COUNTIFS does not spill.

9. Since which Excel version is =COUNTIFS available?

A. Excel 2019
B. Excel 365
C. Excel 2007 (Compatibility)
D. Excel 2007 ✓

Explanation: Version: “Excel 2007”.

10. Is argument “criteria_range1” required in =COUNTIFS?

A. —
B. Yes
C. No
D. Yes ✓

Explanation: “criteria_range1” is required.