Quiz › Formulas & Functions › COUNT, COUNTA, COUNTIF

COUNT, COUNTA, COUNTIF: Excel Quiz

5 quick questions. Pick an answer to see if you are right.

A1 = 10, A2 has the word Hi, A3 is empty, A4 = 20. What will this formula return?
=COUNT(A1:A4)
- A. 1
- B. 2
- C. 3
- D. 4
Show the answer
B — 2. COUNT counts numbers only: 10 and 20.
A1 = 10, A2 has the word Hi, A3 is empty, A4 = 20. What will this formula return?
=COUNTA(A1:A4)
- A. 2
- B. 3
- C. 4
- D. 1
Show the answer
B — 3. COUNTA counts every cell that is not empty: 10, Hi and 20.
A1 = 10, A2 has the word Hi, A3 is empty, A4 = 20. What will this formula return?
=COUNTBLANK(A1:A4)
- A. 3
- B. 1
- C. 2
- D. 0
Show the answer
B — 1. Only A3 is empty.
A1:A5 has 10, 60, 45, 80, 50. What will this formula return?
=COUNTIF(A1:A5,">50")
- A. 1
- B. 2
- C. 3
- D. 5
Show the answer
B — 2. Only 60 and 80 are more than 50.
A1:A5 has 10, 60, 45, 80, 50. What will this formula return?
=COUNTIF(A1:A5,">=50")
- A. 4
- B. 3
- C. 5
- D. 2
Show the answer
B — 3. >= also counts 50 itself: 60, 80 and 50.