Как пользоваться функцией COUNTBLANK в Excel

Русский Английский
СЧИТАТЬПУСТОТЫ COUNTBLANK

The COUNTBLANK function in Excel and Google Sheets is designed to count the number of empty cells within a specified range.

Syntax:

In Excel: =COUNTBLANK(range)

In Google Sheets: =COUNTBLANK(range)

Potential use cases:

  • Counting the number of empty cells in a column or row.
  • Calculating the percentage of empty values in a range.
  • Checking for the existence of empty cells across a spreadsheet.

Example of usage in Excel:

Consider the following data range where we need to count the empty cells:

10 25
15

To count the empty cells in this range, use the formula =COUNTBLANK(A1:C2). This formula will return 3, indicating that there are three empty cells in the specified range.

Example of usage in Google Sheets:

Assume we have a similar data range in Google Sheets:

5 8
12

To count the empty cells in this range with the COUNTBLANK function, enter the formula =COUNTBLANK(A1:C2). This will yield a result of 3, reflecting that three cells in the range are empty.

Больше информации: https://support.microsoft.com/ru-ru/office/функция-считатьпустоты-6a92d772-675c-4bee-b346-24af6bd3ac22

Другие функции
Возвращает обратное значение для F-распределения вероятности
Возвращает распределение Вейбулла
Вычисляет дисперсию для генеральной совокупности, включая числа, текст и логические значения