Как пользоваться функцией 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