What Excel formula should be used to count the number of empty cells in the following dataset?
A) COUNTIF(A6:H17, "")
B) COUNTIF(A1:H17, "")
C) COUNTIF(A6:H17, 0)
D) COUNTIF(A1:H17, Empty)
E) COUNT(A6:H17, "")

Question

What Excel formula should be used to count the number of empty cells in the following dataset? 
A) COUNTIF(A6:H17, "") 
B) COUNTIF(A1:H17, "") 
C) COUNTIF(A6:H17, 0) 
D) COUNTIF(A1:H17, Empty) 
E) COUNT(A6:H17, "")

Quizplus · Accepted Answer

The COUNTIF function allows you to count the number of cells in a range that meet a certain criteria. In this case, the criteria is an empty cell, which is represented by two quotation marks (""), so the formula should be COUNTIF(A6:H17, "").

What Excel Formula Should Be Used to Count the Number