Which Excel function counts the number of empty cells in specified range,…
2024
Which Excel function counts the number of empty cells in specified range, which is its only argument?
----------------------------------------
कौन-सा एक्सेल फंक्शन तर्क में दी गई खाली सेल की संख्या की गणना करता है?
- A.
COUNT
- B.
COUNTA
- C.
COUNTBLANK
- D.
COUNTB
Attempted by 79 students.
Show answer & explanation
Correct answer: C
The COUNTBLANK function is a built-in statistical function in Microsoft Excel used to determine the number of empty cells in a continuous cell range.
Syntax:
=COUNTBLANK(range)
range (Required): The only argument for this function. It represents the group of cells from which you want to count the blank cells (e.g.,
=COUNTBLANK(A1:B10)).
Important Note: Cells that contain formulas that return an empty text string ("") are also counted as blank or empty cells by this function, even though they technically contain a formula.