Syntax
=COUNT(value1, [value2], ...)Arguments
| Argument | Required | Description |
|---|---|---|
value1 | Required | A value, cell or range to count |
value2 | Optional | More values or ranges |
How to use COUNT
COUNT takes 1 required argument and 1 optional argument, and accepts more values in the same pattern. Type =COUNT( 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.
=COUNT(1, "x", 3)Result =COUNT(A1:A4)Result Data in the sheet
| A | |
|---|---|
| 1 | 5 |
| 2 | text |
| 3 | 7 |
| 4 | TRUE |
Related statistical functions
- CHISQ.TESTReturns the chi squared test of independence: the probability of the observed values given the expected ones.
- CONFIDENCE.NORMReturns the margin of error of a population mean using a normal distribution.
- CONFIDENCE.TReturns the margin of error of a population mean using Student's t distribution.
- CORRELReturns the correlation coefficient of two sets of numbers.
- COUNTACounts the cells and values that are not empty.
- COUNTBLANKCounts the empty cells in a range, including cells holding empty text.
- 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.