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

In =COUNTIFS, which is argument #2?

Question 2 of 10 2/10

How many arguments does =COUNTIFS have in total?

Question 3 of 10 3/10

Which statement about =COUNTIFS is correct?

Question 4 of 10 4/10

In =COUNTIFS, which is argument #3?

Question 5 of 10 5/10

Which is the correct syntax of =COUNTIFS?

Question 6 of 10 6/10

Is =COUNTIFS volatile?

Question 7 of 10 7/10

How many optional arguments does =COUNTIFS have?

Question 8 of 10 8/10

Which formula is a valid example of =COUNTIFS?

Question 9 of 10 9/10

What is the type of argument “criteria1” in =COUNTIFS?

Question 10 of 10 10/10

Does =COUNTIFS return a dynamic array?

Click a question to see the answer.

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

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

Explanation: Argument #2 is “criteria1”.

2. How many arguments does =COUNTIFS have in total?

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

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

3. Which statement about =COUNTIFS is correct?

A. Only works in old versions
B. Each range's criteria is applied one cell at a time. If all of the first cells meet their associated criteria, the count increases by 1. If all of the second cells meet their associated criteria, the count increases by 1 again, and so on until all of the cells are evaluated.
C. Select entire column for best performance
D. Each additional range must have the same number of rows and columns as the criteria_range1 argument. The ranges do not have to be adjacent to each other. ✓

Explanation: Correct: Each additional range must have the same number of rows and columns as the criteria_range1 argument. The ranges do not have to be adjacent to each other.

4. In =COUNTIFS, which is argument #3?

A. lookup_value
B. criteria_range2 ✓
C. criteria1
D. value

Explanation: Argument #3 is “criteria_range2”.

5. Which is the correct syntax of =COUNTIFS?

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

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

6. Is =COUNTIFS volatile?

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

Explanation: COUNTIFS is not volatile.

7. How many optional arguments does =COUNTIFS have?

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

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

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

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

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

9. What is the type of argument “criteria1” in =COUNTIFS?

A. Text
B. Any type ✓
C. Date
D. Logical

Explanation: Type of “criteria1” is “Any type”.

10. Does =COUNTIFS return a dynamic array?

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

Explanation: COUNTIFS does not spill.