Syntax
=COUNTBLANK(range)Arguments
| Argument | Required | Description |
|---|---|---|
range | Required | The range to check |
How to use COUNTBLANK
COUNTBLANK takes 1 required argument. Type =COUNTBLANK( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=COUNTBLANK(A1:A4)Result Data in the sheet
| A | |
|---|---|
| 1 | 5 |
| 2 | |
| 3 | x |
Related statistical functions
- CONFIDENCE.TReturns the margin of error of a population mean using Student's t distribution.
- CORRELReturns the correlation coefficient of two sets of numbers.
- COUNTCounts how many numbers are in a list or range.
- COUNTACounts the cells and values that are not empty.
- COUNTIFCounts the cells in a range that meet a condition.
- COUNTIFSCounts the cells that meet all of several conditions.
- COVARIANCE.PReturns the population covariance of two sets of numbers.
- COVARIANCE.SReturns the sample covariance of two sets of numbers.
- DEVSQReturns the sum of squared deviations of the numbers from their mean.